CHAPTER 9

image

Working with Strings

by Andy Roberts

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 O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.