Character String Functions Supported by SQL Server 2005 in SQL Server

Q

What Are the Character String Functions Supported by SQL Server 2005 in SQL Server Transact-SQL?

✍: FYIcenter.com

A

SQL Server 2005 supports 23 character string functions:

  • ASCII(char) - Returning the code value of a non-Unicode character.
  • CHAR(int) - Returning the non-Unicode character of a code value.
  • CHARINDEX(word, string, start_location) - Returning the location of the searched "word" in a string.
  • DIFFERENCE(string1, string2) - Returning an integer value that indicates the difference between the SOUNDEX values of two strings.
  • LEFT(string, length) - Returning a substring of "length" character from the left hand side.
  • LEN(string) - Returning the number of characters in the string.
  • LOWER(string) - Returning the same string with all upper case characters converted to lower case.
  • LTRIM(string) - Returning the same string with leading spaces removed.
  • NCHAR(int) - Returning the Unicode character of a code value.
  • PATINDEX(pattern, string) - Returning the location of the "pattern" in a string.
  • QUOTENAME(string, quote) - Returning the same string enclosed in "quote".
  • REPLACE(string, old, new) - Returning the same string with "old" replaced by "new".
  • REPLICATE(string, number) - Returning the same string repeated "number" of times.
  • REVERSE(string) - Returning the same string with all character positions reversed.
  • RIGHT(string, length) - Returning a substring of "length" characters from the right hand side.
  • RTRIM(string) - Returning the same string with trailing spaces removed.
  • SOUNDEX(string) - Returning a four-character (SOUNDEX) code to evaluate the similarity of two strings.
  • SPACE(length) - Returning a string of "length" space characters.
  • STR(number, precision, scale) - Returning a string representation of a numeric value.
  • STUFF(string, start, length, new) - Returning the same string with one part being replaced.
  • SUBSTRING(string, start, length) - Returning a substring.
  • UNICODE(nchar) - Returning the code value of a Unicode character.
  • UPPER(string) - Returning the same string with all lower case characters converted to upper case.

 

Inserting New Line Characters into Strings in SQL Server

Converting Unicode Strings to Non-Unicode Strings in SQL Server

Character Strings and Binary Strings in SQL Server Transact-SQL

⇑⇑ SQL Server Transact-SQL Tutorials

2017-03-07, 1485🔥, 0💬