SQL Server String, Cursor, Security and Rowset Functions
This article continues the series on system-supplied functions by discussing the string, security, cursor, and rowset functions. We also introduce you to a couple of functions that are not mentioned in the SQL Server online documentation.
String functions let you extract various portions of character strings, change the case of strings, concatenate and reverse strings, and perform many other types of manipulations. All built-in string functions are deterministic, with the exception of CHARINDEX and PATINDEX. (I've already covered the string functions in another article posted on this website. Please refer to "String Manipulations with SQL Server 2000" for an overview and examples of those functions.)