Returns 1 if the Unicode value at position start is the higher half of a surrogate pair (which should appear first in the pair). Otherwise, returns 0. This function allows you to write explicit code for surrogate handling.
uhighsurr(uchar_expr, start)
is a character-type column name, variable, or constant expression of unichar or univarchar type.
specifies the character position to investigate.
uhighsurr, a string function, allows you to write explicit code for surrogate handling. Specifically, if a substring starts on a Unicode character where uhighsurr is true, extract a substring of at least 2 Unicode values (substr does not extract half of a surrogate pair).
If uchar_expr is NULL, uhighsurr returns NULL.
ANSI SQL – Compliance level: Transact-SQL extension.
Any user can execute uhighsurr.
Documentation Transact-SQL Users Guide
Function ulowsurr