>I use TEXT to create SQL commands e.g.:
>
>

>TEXT TO lc_sqlstring 
>        select *   from hhpickup  where left(storecode,11) = ?lc_pickupstore and ( CAST(pickupdate AS date) =
>         ?ld_date1 OR
>         CAST(pickupdate AS date) =  ?ld_date2 OR
>         CAST(pickupdate AS date) =  ?ld_date3)
>         AND NOT EXISTS (SELECT idcol FROM depdetail WHERE store = hhpickup.storecode AND RIGHT(RTRIM(LTRIM(sealnumber)),7) =
>		  RIGHT(RTRIM(LTRIM(hhpickup.sealnumber)),7)
>         and postingdate <= ?ld_entdate)
>         ORDER BY sealnumber
>
>ENDTEXT
>

>That worked for hundreds of thousands of different iterations but today, in one case, the text appeared on the form that was executing it. I added NOSHOW and all was well again.
>What happened?

What tore said... Just jumping in with a why not:
inlist( CAST(pickupdate AS date), ?ld_date1, ?ld_date2, ?ld_date3)

instead of the OR construct?