ASCII to Decimal and Decimal to ASCII in SQL Server

ASCII to decimal conversion can be done as shown below

1_ASCII to Decimal and Decimal to ASCII in SQL Server

The ASCII function takes one character as parameter and returns its equivalent integer ASCII value.

Decimal to ASCII conversion is done as shown below

2_ASCII to Decimal and Decimal to ASCII in SQL Server

The CHAR function accepts an integer value returns equivalent ASCII value.

 

Like us on FaceBook  |  Join the fastest growing SQL Server group on FaceBook

Data Platform Virtual Summit 2020

Subscribe to SQLServerGeeks YouTube channel. If you want more learning content in your inbox, subscribe to SQLServerGeeks Bulletin.

SQLServerGeeks YouTube | SQLServerGeeks Bulletin | SQLServerGeeks Twitter

Leave a Reply

Your email address will not be published. Required fields are marked *