C#, SQL Server, WCF, MVC and ASP .NET video tutorials for beginners
In this video we will learn about the commonly used built-in string functions in SQL server 2008
1. ASCII(Character_Expression) – Returns the ASCII code of the given character expression.
2. CHAR(Integer_Expression) – Converts an int ASCII code to a character. The Integer_Expression, should be between 0 and 255.
3. LTRIM(Character_Expression) – Removes blanks on the left handside of the given character expression.
4. RTRIM(Character_Expression) – Removes blanks on the right hand side of the given character expression.
5. LOWER(Character_Expression) – Converts all the characters in the given Character_Expression, to lowercase letters.
6. UPPER(Character_Expression) – Converts all the characters in the given Character_Expression, to uppercase letters.
7. REVERSE(‘Any_String_Expression’) – Reverses all the characters in the given string expression.
8. LEN(String_Expression) – Returns the count of total characters, in the given string expression, excluding the blanks at the end of the expression.
