>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

dDdate=table2.date
cSelect="selec * from table where table.date<=dDdate"
&cSelect.