SQL - String Functions


SQL string functions are used primarily for string manipulation. The following table details the important string functions −

Sr.No. Function & Description
1 ASCII()

Returns numeric value of left-most character

2 CHAR()

Returns the character for each integer passed

3 CHARINDEX()

Returns the position of a substring within the given string.

4 CONCAT_WS()

Returns concatenate with separator

5 CONCAT()

Returns concatenated string

6 DIFFERENCE()

returns an integer value measuring the difference between the SOUNDEX() values of two different expressions(strings).

7 ESCAPE()

Returns a text with escaped characters.

8 FORMAT()

Returns the formatted string.

9 LEFT()

Returns the extracting string.

10 LEN()

Returns the length of the given string.

11 LOWER()

Returns returns the lower case of the given string.

12 LTRIM()

Returns a string after removing all the white spaces and characters from the string found on the left side.

13 NCHAR()

Returns the Unicode character based on the number code.

14 PATINDEX()

Returns the position of a pattern in a string.

15 QUOTENAME()

Returns a string with a delimiter

16 REPLACE()

Returns a new string by replacing all the occurrences of the particular part of a string (substring) with a specified string.

17 REPLICATE()

Returns the repeated value.

18 REVERSE()

Returns a reversed string.

19 RIGHT()

Returns the rightmost characters from the actual(current) string.

20 RTRIM()

Returns a string after removing all trailing blanks.

21 SOUNDEX()

Returns the Soundex string.

22 SPACE()

returns a string consisting of N number of space characters.

23 STR()

Returns a number as string.

24 STRING_AGG()

Concatenates the values of string expressions and places separator values between them.

25 STRING_SPLIT()

Splits a string into rows of substrings.

26 STUFF()

Returns a new string by inserting the second expression at the specified deleted place.

27 SUBSTRING()

Returns the part of the character.

28 TRANSLATE()

Returns a string from the first argument.

29 TRIM()

Returns a trimmed string.

30 UNICODE()

Returns an integer value of the first character.

31 UPPER()

returns a string that has all the characters in upper case.

Advertisements