Returns the left part of a character string with the specified number of characters.
Syntax:
LEFT ( character_expression , integer_expression )
Function
Description
LEN
Returns the number of characters, instead of the number of bytes, of the specified string expression, excluding trailing blanks.
Syntax:
LEN ( string_expression )
Function
Description
LOWER
Returns a character expression after converting uppercase character data to lowercase.
Syntax:
LOWER ( string_expression )
Function
Description
LTRIM
Returns a character expression after it removes leading blanks.
Syntax:
LTRIM ( string_expression )
Function
Description
NCHAR
Returns the Unicode character with the specified integer code, as defined by the Unicode standard.
Syntax:
NCHAR ( integer_expression )
Function
Description
PATINDEX
Returns the starting position of the first occurrence of a pattern in a specified expression, or zeros if the pattern is not found, on all valid text and character data types.
Syntax:
PATINDEX ( '%pattern%' , expression )
Function
Description
QUOTENAME
Returns a Unicode string with the delimiters added to make the input string a valid Microsoft SQL Server 2005 delimited identifier.