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