LEFT (Transact-SQL)

Returns the left part of a character string with the specified number of characters. ... When using SC collations, the integer_expression parameter counts a UTF-16 surrogate pair as one character. For more information, see Collation and Unicode Support.

technet.microsoft.com