Yes and this is the entire string :

sqlstr = 'select * from MERCHANT ;
WHERE MERCHANT.AMDINX BETWEEN;
?STDATE AND ?ENDATE'

>Hi Mark,
>
>>SQLSTRX='SELE * FROM MERCHANT'
>
>I don't think you can abbreviate SELECT. Does it work if you don't?
>HTH