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.