Built-in Functions - String Functions

--Main link
--http://sqlserverpedia.com/wiki/Built-in_Functions_-_String_Functions#STUFF_Function



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.
String manipulations are an inherent part of any programming language. In transactional systems you might have to format the string accepted on a user-interface screen; in reporting situations you might need to concatenate or compare strings. Transact-SQL includes numerous functions that are fairly simple to use.

Contents

[hide]

• 1 LEFT Function
• 2 RIGHT Function
• 3 LTRIM and RTRIM Functions
• 4 SUBSTRING Function
• 5 REVERSE Function
• 6 CHARINDEX and PATINDEX Function
• 7 REPLACE Function
• 8 STUFF Function
• 9 LEN Function
• 10 REPLICATE Function
• 11 SPACE Function
• 12 UPPER and LOWER Functions
• 13 ASCII Function
• 14 UNICODE Function
• 15 CHAR Function
• 16 NCHAR Function
• 17 QUOTENAME Function
• 18 STR Function
• 19 SOUNDEX and DIFFERENCE Functions
• 20 More SQL Server Functions 
 

More SQL Server Functions

• SQL Server 2005 String Functions - like LTRIM, REPLACE, CHARINDEX, STUFF
• SQL Server 2005 Cursor Functions - like @@FETCH, CURSOR_STATUS
• SQL Server 2005 Date & Time Functions - like DATEPART, DATEDIFF, GETUTCDATE
• SQL Server 2005 Mathematical Functions - like RAND, CEILING, FLOOR
• SQL Server 2005 Text and Image Functions - like PATINDEX(), TEXTPTR()
• SQL Server 2005 System Functions - like COALESCE, ISNUMERIC, ERROR_MESSAGE
• SQL Server 2005 Configuration Functions - like @@MAX_PRECISION, @@SERVERNAME
• SQL Server 2000 Functions - if you can only develop against SQL Server 2000, this page contains the list of functions supported by 2000.