Jaa


CODEPOINT (SSIS)

Returns the Unicode code point of the leftmost character of a character expression.

Syntax

CODEPOINT(character_expression)

Arguments

  • character_expression
    Is a character expression whose leftmost character will be evaluated.

Result Types

DT_UI2

Remarks

character_expression must have the DT_WSTR data type.

CODEPOINT returns a null result if character_expression is null or an empty string.

Examples

This example uses a string literal. The return result is 77, the Unicode code point for M.

CODEPOINT("Mountain Bike")

This example uses a variable. If Name is Touring Front Wheel, the return result is 84, the Unicode code point for T.

CODEPOINT(@Name)

See Also

Other Resources

Functions (SSIS)

Help and Information

Getting SQL Server 2005 Assistance