Have you wondered what the ASCII value of a character is whilst using SQL Server? Or needed to quickly check the ASCII value? Or wondered how the ASCII Function worked?
Well the other day I saw one of the developers using the ASCII function which I was not familiar with so I decided to a bit of exploring.
The above query shows how easy it is to return ASCII values.


The second query shows how you can get the ASCII values from values within a column.
I hope that you liked the above post and hope that you can tell me about your adventures with the ASCII function.
Originally published at https://parvtheitgeek.com on April 12, 2015.