different way perhaps

[DeadManWalks]

select Max(POFound) into :RecordFound
          From (
                  select Count(Ponumb) PoFound
                  from pomhst
                  Where Char(Ponumb) = :Mix_Field6
                  union
                  select Count(Ponumb) POFound
                  from pomhdr
                  Where Char(Ponumb) = :Mix_Field6 ) POTest

So a mix_field6 might be in one of the 2 files. i just want to know if it is found at all.

This works and is fast. i am just wondering about a different method.

Thanks.

[Viking]

Re: different way perhaps

WHERE EXISTS can be used to determine if a record is returned in a subquery. Maybe you can use that in this case?