Microsoft SQL Server Unicode


Example

Returns the integer value representing the Unicode value of the first character of the input expression.

Parameters:

  1. Unicode character expression. Any valid nchar or nvarchar expression.
SELECT UNICODE(N'Ɛ') -- Returns 400

DECLARE @Unicode nvarchar(11) = N'Ɛ is a char'
SELECT UNICODE(@Unicode) -- Returns 400