String functions Of sql server 2005?

Answer 1

SQL Server provides us with a variety of string functions. Some of them are:

• LOWER - To convert a string to lower case
• UPPER - To convert a string to upper case
• LTRIM - To trim blank spaces from the left side of the string
• RTRIM - To trim blank spaces from the right side of the string
• SUBSTRING - To pick up specific portions of a string
• REVERSE - To reverse the input string
• REPLACE - To replace the character at a specified position of a string with another
• etc.