How to view the ASCII or Unicode encoding of a letter in SQL Server

Reference article: Public number article

has always misunderstood left and right in SQL, and always thought it was like this.

SELECT  from WHERE = 1

To execute such a sentence:

SELECT  Left (Mobile,2fromWHERE=1SELECTRight (mobile,2  fromWHERE=1

The result is this:

And I think in my mind:

I think only the second one appears.

Run it and know it.

How to view the ASCII encoding of a character in SQL, so easy!!

Select ASCII ('a') SELECT CHAR (charNum) SELECT UNICODE ('a') unicodenum

The result is this.

Also, Unicode encoding encodes only the first

SELECT UNICODE (the $SELECTUNICODE(9

How to view the ASCII or Unicode encoding of a letter in SQL Server