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

   

Leave a Reply

Your email address will not be published.