Transact SQL System Variables and Functions - Professional SQL Server 2005 Reporting Services - page 649

Function Name Return Type Description

Returns a specific number of characters from
the rightmost side of a character string.

RIGHT() VarChar

Removes trailing spaces from the right side
of a character string.

RTRIM() VarChar

Returns a four-character alphanumeric
string representing the approximate
phonetic value of a word, based on the U.S.
Census Soundex algorithm.

SOUNDEX() Char

Returns a character string consisting of a
specified number of spaces.

SPACE() Char

Returns a character string value that repre-
sents a converted numeric data type. Three
arguments include the value, the
overall length, and the number of decimal
positions.

STR() Char

(character or Returns a character string with one string

STUFF()

binary types, placed into another string at a given

depending on position and for a specified length.

input)

(character or Returns a portion of a character string from

SUBSTRING()

binary types, a specified position and for a specified

depending on length.

input)

Returns the numeric Unicode character
value for a specified character.

UNICODE() Int

Converts a character string to all uppercase
characters.

UPPER() VarChar

System

Function Name Return Type Description

Each session is associated with an
application name, passed to the database
server by explicit program code or by the
driver or data provider.

APP_NAME() nVarChar

(same type as input) Returns the first non-null value from a

comma-delimited list of expressions.

COALESCE()

Returns the value of a specific property for
a specified collation. Properties include
CodePage , LCID , and ComparisonStyle .
Table continued on following page

COLLATIONPROPERTY() Sql_Variant