[Genius Live]

String Functions in T-SQL

ASCII (character) : Returns the ASCII code value of the leftmost character of character
CHAR (int) : Converts the integer ASCII code int to a character
CHARINDEX (search, expression, [start]) : Returns starting position (int) of first occurrence of the string search within table or string expression starting from position start
DIFFERENCE (expression1, expression2) : Returns the difference between the SOUNDEX values of the two character expressions as an integer
LEFT (expression, int): Returns part of character string expression starting at int characters from the left
LEN (expression) : Returns the number of characters of the string expression, excluding trailing blanks
LOWER (expression) : Returns character expression after converting uppercase string to lowercase
LTRIM (expression) : Returns a character string after removing all leading blanks
NCHAR (int) : Returns the Unicode character with the given integer code
PATINDEX ('%pattern%', expression) : Returns starting position of the first occurrence of a pattern in a specified expression, or zeros if the pattern is not found, on all valid text and character data types
REPLACE (expression1,expression2,expression3) : Replaces all occurrences of the second given string expression in the first string expression with a third expression
QUOTENAME (character_string[, quote_character]) : Returns a Unicode string with the delimiters added to make the input string a valid Microsoft SQL Server delimited identifier
REPLICATE (expression, int) : Repeats a character expression a specified number of times
REVERSE (expression) : Returns the reverse of a character expression
RIGHT (expression, int): Returns part of character string expression starting at int characters from the right
RTRIM (expression) : Returns a character string after removing all trailing blanks
SOUNDEX (expression) : Returns a four-character (SOUNDEX) code
SPACE (int) : Returns a string of int spaces
STR (float_expression[, length[, decimal]]) : Returns character data converted from numeric data
STUFF (expression1, start, length, expression2 ) : Deletes a specified length (length) of characters from expression1 and inserts another set (expression2) at a specified starting point (start) of expression1
SUBSTRING (expression, start, length) : Returns part of character, binary, text expression or image expression starting from position start with length length
UNICODE (char) : Returns the Unicode int value for the first character of char
UPPER (expression) : Returns a character expression after converting lowercase string to uppercase