Obtaining ASCII Values from Characters in SQL

With the ASCII function you can return a certain character's ASCII value, as shown in the following example:

SELECT ASCII('A') AS A, ASCII('B') AS B, 
ASCII('a') AS a, ASCII('b') AS b, 
ASCII(1) AS [1], ASCII(2) AS [2],
ASCII('!') AS [!], ASCII('@') AS [@],
ASCII('\') AS [\], ASCII('/') AS [/]

Hannes Du Preez

Submit a Tip

Browse "Database Development" Tips

Browse All Tips

Thanks for your registration, follow us on our social networks to keep up-to-date