Home Library Learn Samples Downloads Support Community Forums
1 out of 1 rated this helpful - Rate this topic

CODEPOINT (SSIS Expression)

SQL Server 2012

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

Copy 
CODEPOINT(character_expression)
character_expression

Is a character expression whose leftmost character will be evaluated.

character_expression must have the DT_WSTR data type.

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

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

Copy 
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.

Copy 
CODEPOINT(@Name)
Did you find this helpful?
(1500 characters remaining)

Community Additions

ADD
© 2013 Microsoft. All rights reserved.
|
Site Feedback
© 2013 Microsoft. All rights reserved.