MSSQL String Functions 65 codes

1 % is for any length of letters

2 ^ specifies the negation of a range or a list of characters

3 _ is for one letter

4 Any of the wildcard characters (%, _ [, ], or ) enclosed in square brackets stand for themselves

5 ASCII

6 ASCII(A)

7 Begin with a character in the range C through F

8 CHAR

9 CHAR(65)

10 CHAR(CAST(0x3A as int))

11 CHARINDEX

12 CHARINDEX()

13 CHARINDEX(Mars, The stars near Mars are far from ours)

14 COLLATE Latin1_General_CS_AS

15 Combine CHARINDEX with substring

16 Combine Lower() Upper() and substring() function to capital the first letter in a word

17 DATALENGTH()

18 DATALENGTH() for for Unicode character set

19 DATALENGTH(@Value)

20 DIFFERENCE

21 DIFFERENCE()

22 Get string to the right

23 LEFT

24 LEFT()

25 LEFT(Name,1)

26 LEN()

27 LEN(@Value)

28 Like with escape

29 LOWER

30 LTRIM

31 NCHAR

32 PATINDEX

33 PATINDEX(%M_rs%, The stars near Mars are far from ours)

34 QUOTENAME

35 REPLACE

36 REPLACE spaces

37 REPLACE()

38 REPLICATE

39 REPLICATE string

40 REPLICATE(, 20 - LEN(Name))

41 REVERSE

42 REVERSE()

43 RIGHT

44 RIGHT()

45 RIGHT(@RIGHT_STRING,10)

46 SELECT DIFFERENCE ( Fleas, Fleece)

47 SOUNDEX

48 SOUNDEX()

49 SPACE

50 SPACE(20 - LEN(Name))

51 Specifying an overall length greater than the length of the value, decimal point, and the decimal value, the result will

52 STR

53 STR() Function

54 STR() function right-fills the decimal value with zeros

55 STR(100 325,7)

56 STR(123 456789, 8, 4)

57 STUFF()

58 STUFF(string_used_as_basis, start_point, length, string_to_insert)

59 SUBSTRING()

60 SUBSTRING(string_to_remove_string_from, start_position, length)

61 Substring

62 UNICODE

63 UPPER

64 Use set to assign value to a variable with replicate function

65 Using the DIFFERENCE() function to compare Redmond with Renton