>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.


SELECT M.*, SUBSTR("Ford ,Chevy ,Buick ,Pontiac " ;
"Cadillac,Chrysler",(M.nMake-1)*9+1,8) AS "cMake" ;
From MyFile M