Returns the Unicode scalar value for the first Unicode character in an expression.
uscalar(uchar_expr)
is a character-type column name, variable, or constant expression of unichar, or univarchar type.
uscalar, a string function, returns the Unicode value for the first Unicode character in an expression.
If uchar_expr is NULL, returns NULL.
If uscalar is called on a uchar_expr containing an unmatched surrogate half, and error occurs and the operation is aborted.
ANSI SQL – Compliance level: Transact-SQL extension.
Any user can execute uscalar.
Documentation Transact-SQL Users Guide
Functions ascii