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 https://parvtheitgeek.com on April 12, 2015.

Advertisement

Published by Parvinder Nijjar

I blog at ParvTheITGeek.com

Leave a Reply

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

WordPress.com Logo

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

Facebook photo

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

Connecting to %s

%d bloggers like this: