>Right now the table is small, but it has the potential to have thousands of records. Do you know a better way of replacing the abbreviations with the full words?
>
>Thanks,
>
>-Michelle

Why not create a cursor with the statuses, then join the table to the cursor...

select field1,field2,field3,status.cstatus as cstatus ;
from myfile,status ;
where myfile.cstatus = status.cstatus

...........
You can even index the cursor on cstatus, but with 3 records I don't think it will make a difference. This was, if you get a new status, you wont need to modify some iiif function.

BOb