Personnaly, I would do it with iif if there is only a few possibility (In most of the case, I would have description table that I can link and that provides more flexibility on a user point-of-view).
In the iif case, it would go as is:
SELECT IIF(code=1,"Ford",IIF(code=2,"Chevy",IIF(code=3,"Buick"))) AS code,;
FROM table etc...

Eric
>I am doing a SELECT - SQL command that gathers all of my data for my report. But is there a way within the SQL command that I can translate some of the data that has codes to represent data which is really strings of text?
>
>For example my report shows a column of codes as in 1, 3, 6, 4, 6
>1 = Ford
>2 = Chevy
>3 = Buick
>4 = Pontiac
>5 = Cadillac
>6 = Chrysler
>
>Is there an easy way during the SELECT to translate the codes on the fly so I don't have to play games in the report or before the report to translate the codes? So the word Ford prints instead of the code 1 and so on.
>
>I am simply looking for a shortcut or better way. Thanks for your able-bodied assistance ahead of time.