Common functions in the "SQL Server" section

Some commonly used string functions

function Name	Description	Example
CHARINDEX	Used to find the starting position of a specified string in another string	charindex ( expression1 , expression2 [, start_location ] ) parameters: expression1 expression1 maximum length is limited to 8,000 characters. expression2 P> start_location bigint expression that is the starting position of the search. If start_location is not specified, or start_location is negative or 0, the search starts at the beginning of expression2 .
len	return string length	len ( string_expression ) parameters: string_expression P> string expression that requires a value. string_expression can be a constant, a variable, or a character column or a binary row of data.
LOWER	To lowercase	LOWER ( character_expression ) Parameters: character_expression The expression for the character or binary data. The data type of the character_expression can be a constant, variable, or column. The character_expression must be a data type that can be implicitly converted to varchar . Otherwise, use cast to explicitly convert the character_expression.

Ah, real deal thiosulfate.

Common functions in the "SQL Server" section