StevenMcD
StevenMcD

Reputation: 17482

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

Upvotes: 4

Views: 2336

Answers (1)

spender
spender

Reputation: 120400

You'd want to look at the CHAR function:

select char(64+6)

Upvotes: 6

Related Questions