UNICODE (SQL Server Compact Edition)
Returns the integer value, as defined by the Unicode standard, for the first character of the input expression.
UNICODE ( 'ncharacter_expression' )
An expression whose type can be implicitly converted to nvarchar or ntext.
The following example returns the names of the companies along with the integer value, as defined by the Unicode standard, for the first character of each company name.
SELECT CompanyName, UNICODE(CompanyName)
ORDER BY CompanyName
(1500 characters remaining)
Thank you for your feedback