>Hi, it's friday and I'm going crazy with a simple SQL statement.
>

>csql = "select * from prestacoes where data_venc >= 2005/09/23"
>a = SQLEXEC(nID,csql,"resultado")
>

>returns the data from SQL server as expected
>But, if I run this one:
>

>csql = "select * from prestacoes where data_venc <= 2006/02/28"
>a = SQLEXEC(nID,csql,"resultado")
>

>
>Returns no record
>
>But if I run those same statements in QA, I get the data as expected in both cases.
>Why when I use "< " ou "< =" I dont get those values that exist in table prestacoes.
>
>TIA
>Peter

Peter,
Try:

m.ldDate = {^2006/02/28}
csql = "select * from prestacoes where data_venc <= ?m.ldDate"
SQLEXEC(nID,csql,"resultado")

Cetin