I have a simple SQL query that returns some data in the form of numbers.
i.e. I have a column marked [race] and the numbers returned in this column can be any number bwteen 1-6.
If the number is '1' in this column, I would like it to say 'Caucasian' if it is 2, it should say 'Asian' and so on.
How would I do this?