CHAPTER 9
Working with Strings
This next set of recipes demonstrates SQL Server’s string functions. String functions provide a multitude of uses for your Transact-SQL programming, allowing for string cleanup, conversion between ASCII and regular characters, pattern searches, removal of trailing blanks, and much more. Table 9-1 lists the different string functions available in SQL Server.
Table 9-1. String Functions
| Function Name(s) | Description |
|---|---|
| CONCAT | The CONCAT function concatenates a variable list of string values into one larger string. |
| ASCII and CHAR | The ASCII function takes the leftmost character of a character ... |
Get SQL Server 2012 T-SQL Recipes: A Problem-Solution Approach now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
