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: