views:

68

answers:

1

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

+4  A: 

You'd want to look at the CHAR function:

select char(64+6)
spender
awesome! Thanks
FailBoy