String Function
String function are built in function that operate on string type of data .the string function available in sql server are as follows.
Function | Use | Syntax | Output |
ASCII(Char) | Used to give ascii value of given character | ASCII(‘A’) | 97 |
Char(n) | It takes ascii values as argument and returns character for that ascii value | Char(65) | A |
Left(n,string) | Used to extract ‘n’ no of character from bit of given string | Left(‘Microsoft’,4) | Micr |
Right(String,n) | Used to extract ‘n’ no of character from right of the given string | Right(‘Microsoft’,4) | Soft |
Substring(string,p,n) | Used to extract ‘n’ no of characters starting from position ‘p’ from the given string | Substring(‘Microsoft,3,4’) | cros |
Ltrim(string) | Used to delete all the blank spaces on left of given string | | |
RTrim(strin g) | Used to delete all the blank spaces on right of given string | | |
Stuff(string1,p,n,string2) | Used to replace ‘n’ no of char starting from position ‘p’ in the string string with string2 | Stuff(‘Notepad,1,4,’word’) | Wordpad |
Upper(string) | Used to convert given str to upper case. | Upper(‘microsoft’) | MICROSOFT |
Lower(string) | Used to convert given str to Lower case. | Lower(‘MICROSOFT’) | microsoft |
Len(string) | Used to get no of character in given string | Len(‘microsoft’) | 9 |