SELECT ASCII('Ant') "ascii" FROM DUMMY;
ascii
65
SELECT CHAR (65) || CHAR (110) || CHAR (116) "character" FROM DUMMY;
character
Ant
SELECT CONCAT ('C', 'at') "concat" FROM DUMMY;
concat
Cat
SELECT LCASE ('TesT') "lcase" FROM DUMMY;
lcase
test
SELECT LEFT ('Hello', 3) "left" FROM DUMMY;
left
Hel
SELECT LENGTH ('length in char') "length" FROM DUMMY;
length
14
SELECT LOCATE ('length in char', 'char') "locate" FROM DUMMY;
Locate
11
SELECT LOCATE ('length in char', 'length') "locate" FROM DUMMY;
Locate
1
SELECT LOCATE ('length in char', 'zchar') "locate" FROM DUMMY;
Locate
0
SELECT LOWER ('AnT') "lower" FROM DUMMY;
lower
ant
SELECT LPAD ('end', 15, '12345') "lpad" FROM DUMMY;
lpad
123451234512end
SELECT LTRIM ('babababAabend','ab') "ltrim" FROM DUMMY;
ltrim
Aabend
SELECT NCHAR (65) "nchar" FROM DUMMY;
SELECT REPLACE ('DOWNGRADE DOWNWARD','DOWN', 'UP') "replace" FROM DUMMY;
replace
UPGRADE UPWARD
SELECT RIGHT('HI0123456789', 3) "right" FROM DUMMY;
right
789
SELECT RPAD ('end', 15, '12345') "right padded" FROM DUMMY;
right padded
end123451234512
SELECT RTRIM ('endabAabbabab','ab') "rtrim" FROM DUMMY;
rtrim
endabA
SELECT SUBSTR_AFTER ('Hello My Friend','My ') "substr after" FROM DUMMY;
substr after
Friend
SELECT SUBSTR_BEFORE ('Hello My Friend','My') "substr before" FROM DUMMY;
substr before
Hello
SELECT SUBSTRING ('1234567890',4,2) "substring" FROM DUMMY;
substring
45
SELECT TRIM ('a' FROM 'aaa123456789aa') "trim both" FROM DUMMY;
trim both
123456789
SELECT TRIM (LEADING 'a' FROM 'aaa123456789aa') "trim leading" FROM DUMMY;
trim leading
123456789aa
SELECT UCASE ('Ant') "ucase" FROM DUMMY;
ucase
ANT
SELECT UNICODE ('#') "unicode" FROM DUMMY;
unicode
35
SELECT UPPER ('Ant') "uppercase" FROM DUMMY;
uppercase
ANT