Home > Articles > Data > SQL

SQL Server String, Cursor, Security and Rowset Functions

  • Print
  • + Share This
Baya Pavliashvili continues his series on system-supplied functions by discussing the string, security, cursor, and rowset functions. Also discover some extra features, which are not mentioned in the SQL Server online documentation.
Like this article? We recommend

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

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.)

  • + Share This
  • 🔖 Save To Your Account