Returns 1 if the Unicode value at position start is the low half of a surrogate pair (which should appear second in the pair). Returns 0 otherwise.
is a character-type column name, variable, or constant expression of unichar, or univarchar type.
specifies the character position to investigate.
ulowsurr, a string function, allows you to write explicit code around adjustments performed by substr(), stuff(), and right(). Specifically, if a substring ends on a Unicode value where ulowsurr() is true, the user knows to extract a substring of 1 less characters (or 1 more). substr() does not extract a string that contains an unmatched surrogate pair.
If uchar_expr is NULL, returns NULL.
For general information about string functions, see “String functions”.
SQL92 – Compliance level: Transact-SQL extension.
Any user can execute ulowsurr.