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


I could have used you at the begining of this all. :) As I said in my post to Ed P., I realized that it makes much more sense to join to the stat_codes table.

Thanks,

-Michelle