Using String Functions

String functions are used for various operations on character and binary strings, and they return values commonly needed for operations on character data. Most string functions can be used only on char, nchar, varchar and nvarchar data types or the data types that implicitly convert to them. A few string functions can also be used on binary and varbinary data.

You can use string functions to:

• Retrieve only a portion of a string (SUBSTRING).
• Look for similarities in the sounds of a character string (SOUNDEX and DIFFERENCE).
• Find a starting position for a particular string in a column or expression. For example, the position number of the letter A in “What a beautiful day!”.
• Concatenate or combine strings into one string. For example, combining a first name, last name, and middle name or initial into a full name.
• Convert a nonstring value to a string value (such as converting the value of 15.7 stored as a float to char).
• Inserting a specific string into an existing string. For example, inserting the string “Once” into the existing string of “upon a time” to produce the string “Once upon a time”.