Built in string functions in sql server 2008 Part 22

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