>>If these are the only codes you have, you can write a small CarCodeToCarName function and call it in your SQL statement:
>
>Vlad,
>
>That approach will blow upi if the data is ever moved to a storage system other than VFP. Making a validation table for the codes and using a join to it will translate to any relational databse system.

This is only one of the reasons I said that having that validation table is a better solution! :)

Vlad