Any suggestions? Export (0) Print
Expand All
Collapse the table of content
Expand the table of content
Expand Minimize

UNICODE (SQL Server Compact)

Returns the integer value, as defined by the Unicode standard, for the first character of the input expression.


UNICODE ( 'ncharacter_expression' ) 

'ncharacter_expression'

An expression whose type can be implicitly converted to nvarcharor ntext.

The following example returns the names of the companies together with the integer value, as defined by the Unicode standard, for the first character of each company name.

SELECT [Company Name], UNICODE([Company Name]) AS  Expr1
FROM Customers
ORDER BY [Company Name]
Show:
© 2016 Microsoft