Mega Code Archive

 

Categories / MSSQL Tutorial / String Functions

 

Converting a Character Value to ASCII and Back to Character

34> 35> SELECT ASCII('H'), ASCII('e'), ASCII('l'), ASCII('l'), ASCII('o') 36> GO ----------- ----------- ----------- ----------- -----------          72         101         108         108         111 (1 rows affected)