codepoint-ssis-expression.md

title	CODEPOINT (SSIS Expression)
description	CODEPOINT (SSIS Expression)
author	chugugrace
ms.author	chugu
ms.date	03/01/2017
ms.service	sql
ms.subservice	integration-services
ms.topic	concept-article
helpviewer_keywords	CODEPOINT function leftmost character of expression

CODEPOINT (SSIS Expression)

[!INCLUDEsqlserver-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.

Expression 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

Functions (SSIS Expression)