StevenMcD StevenMcD - 3 months ago 13
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

You'd want to look at the CHAR function:

select char(64+6)