UnityJDBC - String Functions

Summary

Function	Syntax	Description
ASCII	ASCII(expr)	Returns the ascii number of the leftmost character in expr.
BIT_LENGTH	BIT_LENGTH(expr)	Returns the number of bits in expr.
CHAR	CHAR(expr)	Returns a character that has the ASCII code of (expr).
CHAR_LENGTH	CHAR_LENGTH (expr)	Returns the number of characters in (expr).
CONCAT	CONCAT(expr1, expr2)	Appends two or more literal expressions into one string.
CONCATENATE	CONCATENATE(expr1, expr2)	Appends two or more literal expressions into one string.
INSTR	INSTR(str, substr, pos)	Returns the position of the first occurrence of substring substr in string str, starting at position pos.
INSTR	INSTR(str, substr)	Returns the position of the first occurrence of str in substr.
LCASE	LCASE(expr)	Coverts expr into lower case.
LEFT	LEFT(expr, len)	Returns the leftmost len characters from the string expr.
LEN	LEN (expr)	Returns the number of characters in (expr).
LENGTH	LENGTH (expr)	Returns the number of characters in expr.
LOWER	LOWER(expr)	Coverts expr into lower case.
LTRIM	LTRIM(expr)	Removes whitespace at the beginning of the string.
NVL	NVL(expr1, expr2)	If expr1 is an empty string or NULL, replaces with expr2.
OCTET_LENGTH	OCTET_LENGTH(expr)	Returns the number of bytes (octets) in expr.
POSITION	POSITION(str, substr)	Returns the position of the first occurrence of str in substr.
REGEXP_LIKE	REGEXP_LIKE(str, regexp)	Returns true if string str matches regular expression str in regesp.
REPLACE	REPLACE(str, oldstr, newstr)	Replaces all occurences of oldstr by newstr in a string str.
REVERSE	REVERSE(str)	Reverse the string str.
RIGHT	RIGHT(expr, len)	Returns the rightmost len characters from the string expr.
RTRIM	RTRIM(expr)	Removes whitespace at the end of the string.
SPACE	SPACE(expr)	Returns a string consisting of expr space characters.
STUFF	STUFF(str, pos, len, newstr)	Returns the string str with the substring beginning at position pos and len characters long replaced by the string newstr.
SUBSTRING	SUBSTRING(str, len)	Extracts from str starting at the first character len characters.
SUBSTRING	SUBSTRING(str, start, len)	Extracts from str starting at pos len characters.
TRIM	TRIM(expr, type, trimchars)	Removes leading or trailing characters of given type.
TRIM	TRIM(expr)	Removes leading characters and trailing characters from a string.
UCASE	UCASE(expr)	Coverts expr into upper case.
UPPER	UPPER(expr)	Coverts expr into upper case.

Detailed Function Descriptions