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.

 

Regards

Ahmad Osama

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

Follow me on TwitterFollow me on FaceBook