SQL Server Functions

This reference contains string, numeric, date, conversion, and some advanced functions in SQL Server.

Returns the ASCII value for the specific character

Returns the character based on the ASCII code

Returns the position of a substring in a string

Concat with +

CONCAT_WS Adds two or more strings together with a separator

Returns the number of bytes used to represent an expression

Compares two SOUNDEX values, and returns an integer value

Extracts a number of characters from a string (starting from left)

Returns the Unicode character based on the number code

Returns the position of a pattern in a string

Returns a Unicode string with delimiters added to make the string a valid SQL Server delimited identifier