LOWER ( string_expression )
UPPER ( string_expression )
ASCII ( string_expression )
UNICODE ( string_expression )
CHAR ( integer_expression )
NCHAR ( integer_expression )
CHARINDEX ( string_expression1, string_expression2 [ , start_location ] )
LEN ( string_expression )
LTRIM ( string_expression )
RTRIM ( string_expression )
REVERSE ( string_expression )
SPACE ( integer_expression )
LEFT ( string_expression, integer_expression )
RIGHT ( string_expression, integer_expression )
REPLACE ( searched_expression, find_expression, replace_expression )
REPLICATE ( string_expression, integer_expression )
STR ( float_expression [ , length [ , decimal ] ] )
STUFF ( character_expression, start, length, character_expression )
SUBSTRING ( expression, start, length )
PATINDEX ( '%Sql_StringFunctions_Patindex.html%', expression )
The following is a list of functions NOT supported by VistaDB.
SOUNDEX - Returns a four-character (SOUNDEX) code to evaluate the similarity of two strings.
DIFFERENCE - Returns an integer value that indicates the difference between the SOUNDEX values of two character expressions.
QUOTENAME - Returns a Unicode string with the delimiters added to make the input string a valid Microsoft SQL Server delimited identifier.