>Hmmm... Now that's interesting. I didn't know you could do that. I'm wondering if this would work when using SQL in combo boxes. I always hated having to send it to a temp cursor that I had to worry about cleaning up. I'll try that sometime. Good trick, if it works. :)

It works, since it was taken from one of our classes :)

But I would not use it in comboboxes. This was used to check field for uniqueness, so we only want to check, if this SQL produces records (_Tally) and result is not needed.

>
>Thanks,
>
>Michelle
>
>>

select * from (lcAlias) ;
>>			where &lcfield == lcvalue to screen noconsole