SQL Server UNICODE() Function

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

SELECT UNICODE('Atlanta');

Definition and Usage

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

UNICODE(character_expression)

Parameter	Description
character_expression	Required. An nchar or varchar expression

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

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

SELECT UNICODE(CustomerName) AS UnicodeOfFirstChar
FROM Customers;