>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...
>
The big problem with this is that any time there's a change in the list, you have to go back and edit code, rather than just add or change a record in a table...