ASCII String function in SQL Server — Parv The IT Geek

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 on April 12, 2015.


Published by Parvinder Nijjar

I blog at

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: