SQL Server String Functions:
SQL Server string functions are scalar functions that perform an operation on a string input value and return a string or numeric value. All built-in string functions, except for CHARINDEX and PATINDEX, are deterministic. This means they return the same value any time they are called with a specific set of input values.
Tags: SQL Server String Functions SQL SQL Server Functions SQL Server String Functions SQL SQL Server Functions. Character String Data Types and Functions with Sample SQL Statements. Quick reference, Data Type Tables, Function Tables. SQL Server Date and Time Functions SQL Server Configuration Functions SQL Server Aggregate Functions SQL Server Metadata Functions SQL Server Security Functions SQL Server Mathematical Functions SQL Server System Functions.
SQL Server string functions are scalar functions that perform an operation on a string input value and return a string or numeric value. All built-in string functions, except for CHARINDEX and PATINDEX, are deterministic. This means they return the same value any time they are called with a specific set of input values.
MS SQL Server String Functions |
Functions | Description |
---|---|
ASCII() | Returns numeric value of left-most character |
BIN() | Returns a string representation of the argument |
BIT_LENGTH() | Returns length of argument in bits |
CHAR_LENGTH() | Returns number of characters in argument |
CHAR() | Returns the character for each integer passed |
CHARACTER_LENGTH() | A synonym for CHAR_LENGTH() |
CONCAT_WS() | Returns concatenate with separator |
CONCAT() | Returns concatenated string |
CONV() | Converts numbers between different number bases |
ELT() | Returns string at index number |
EXPORT_SET() | Returns a string such that for every bit set in the value bits, you get an on string and for every unset bit, you get an off string |
FIELD() | Returns the index (position) of the first argument in the subsequent arguments |
FIND_IN_SET() | Returns the index position of the first argument within the second argument |
FORMAT() | Returns a number formatted to specified number of decimal places |
HEX() | Returns a string representation of a hex value |
INSERT() | Inserts a substring at the specified position up to the specified number of characters |
INSTR() | Returns the index of the first occurrence of substring |
LCASE() | Synonym for LOWER() |
LEFT() | Returns the leftmost number of characters as specified |
LENGTH() | Returns the length of a string in bytes |
LOAD_FILE() | Loads the named file |
LOCATE() | Returns the position of the first occurrence of substring |
LOWER() | Returns the argument in lowercase |
LPAD() | Returns the string argument, left-padded with the specified string |
LTRIM() | Removes leading spaces |
MAKE_SET() | Returns a set of comma-separated strings that have the corresponding bit in bits set |
MID() | Returns a substring starting from the specified position |
OCT() | Returns a string representation of the octal argument |
OCTET_LENGTH() | A synonym for LENGTH() |
ORD() | If the leftmost character of the argument is a multi-byte character, returns the code for that character |
POSITION() | A synonym for LOCATE() |
QUOTE() | Escapes the argument for use in an SQL statement |
REGEXP | Pattern matching using regular expressions |
REPEAT() | Repeats a string the specified number of times |
REPLACE() | Replaces occurrences of a specified string |
REVERSE() | Reverses the characters in a string |
RIGHT() | Returns the specified rightmost number of characters |
RPAD() | Appends string the specified number of times |
RTRIM() | Removes trailing spaces |
SOUNDEX() | Returns a soundex string |
SOUNDS LIKE | Compares sounds |
SPACE() | Returns a string of the specified number of spaces |
STRCMP() | Compares two strings |
SUBSTRING_INDEX() | Returns a substring from a string before the specified number of occurrences of the delimiter |
SUBSTRING(), SUBSTR() | Returns the substring as specified |
TRIM() | Removes leading and trailing spaces |
UCASE() | Synonym for UPPER() |
UNHEX() | Converts each pair of hexadecimal digits to a character |
UPPER() | Converts to uppercase |