Introduction - If you have any usage issues, please Google them yourself
SQL string functions briefly described. String functions perform different operations on binary data, strings, and expressions. Such functions operate on CHAR, VARCHAR, BINARY, and VARBINARY data types, and can be implicitly converted to CHAR or VARCHAR data type. You can use the string functions in SELECT statements SELECT and WHERE clauses, and expressions.