VistaDB 5
String Functions
The following are STRING functions for SQL supported by VistaDB.

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.

See Also