SQL Server UNICODE() Function

Return an integer value (the Unicode value), for the first character of the input expression

Definition and Usage

The UNICODE() function returns an integer value (the Unicode value), for the first character of the input expression.

Syntax

UNICODE(character_expression)

Parameter Values

Parameter Description
character_expression Required. An nchar or varchar expression

Technical Details

Works in: SQL Server (starting with 2008), Azure SQL Database, Azure SQL Data Warehouse, Parallel Data Warehouse

More Examples

Example

Return an integer value (the Unicode value), for the first character of the input expression:

SELECT UNICODE(CustomerName) AS UnicodeOfFirstChar
FROM Customers;