Sams Teach Yourself SQL in One Hour a Day, Fifth Edition

APPENDIX FGlossary of Common SQL Functions

String Functions

ASCIIASCII(string)

The ASCII() function returns the the ascii code value of the leftmost string passed to it.

CHARCHAR(N1,N2,N3,...)

The CHAR() functions returns the ASCII character string of each of the integer arguments that is passed to it.

COALESCECOALESCE(expression1, expression2, expression3,....)

The COALESCE() function returns the first non-NULL value from the list of arguments passed to it.

CONCATCONCAT(string1, string2,...)

The CONCAT() function is used to concatenate the values of any number of string arguments passed to it.

CONCAT_WSCONACT_WS(separator, string1, string2,.....)

The CONCAT_WS() function is similar to CONCAT(), except that it concatenates the string arguments ...