>Fabio,
>thanks !
>So simple and I didn't see it ..
>
>[ ]'s
>Peter
>
>>>Sergey,
>>>If I run those statements:
>>>

>>>csql = "select * from prestacoes where data_venc >= '2005/09/23'"
>>>csql = "select * from prestacoes where data_venc <= '2006/02/28'"
>>>

>>>It returns this message:
>>>"The conversion of char data type to smalldetime data type resulted in an out-of-range smalldatetime value"
>>>
>>>How to solve this problem now ?
>>>
>>>Peter
>>>
>>
>>
>>

>>csql = "select * from prestacoes where data_venc >= '20050923'"
>>csql = "select * from prestacoes where data_venc <= '20060228'"
>>

Peter,

While you have your answer, the real problem is that SQL Server 2000 always uses ANSI settings for things like datetimes. So

csql = "select * from prestacoes where data_venc <= '2/28/2006 00:00:00'"

should also work. The time portion of the above is optional.