Cetim,
Thanks for showing a way to do it !

[ ]'s
Peter


>>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