StevenMcD StevenMcD - 1 year ago 108
SQL Question

TSQL: Get Letter representation for a Number

Are there any built in functions for SQL where I can pass in a number and it returns a Letter that matches the number. Example, I supply a 6 and it returns a "F"

I realize its an incredibly long shot, just don't wanna re-invent the wheel

Answer Source

You'd want to look at the CHAR function:

select char(64+6)
Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download