>Hi!
>
>How can I use the value of date field inside of a string whose content is a selec statement? Something like this.
>
>cdate=dtoc(table2.date)
>cSelect="selec * from table where table.date<="+cdate
>&cSelect
>
>TIA

i think you mean:
cSelect=" selec * from table where table.date<= ["+cdate+"]"