>>Thanks for the suggestion. So, the above then becomes:
>>
>>
SELECT id, UPPER(firstname), UPPER(lastname), DELETED() as deletedrec ;
>>FROM tablename INTO CURSOR crsTemp
>>And it works.
>>
>It will only work as long as you select from only one table. The minute you join in another table, it will fail to work again.
This is easily circumvented by selecting from this particular table into a temp cursor, then use that in any joins later.
Funny though, I had this idea to have ...deleted() as ... yesterday, but had an impression that someone already said that :). Comes with long threads.