Disclaimer: I am a consultant at Amazon Web Services, and this is my personal blog. The opinions expressed here are solely mine and do not reflect the views of Amazon Web Services (AWS). Any statements made should not be considered official endorsements or statements by AWS.
To determine the code-point value of a Unicode character in SQL Server, you can use
UNICODE() function which is provided by default in SQL Server.
For example, if you want to determine the code-point value of the English letter
A, then you simply need to write the below command in SQL Server.
This will output its code-point value.
You may have to prefix
N before the character if the character is a Non-ASCII character.
N stands for National Language Character Set.
See the below example image: