>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
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only