>What technique do you guys use to check for a date range in SQL2000?
>
>Let's say I want to bring records between 1/1/2003 and 1/10/2003? What Transact SQL (not foxpro syntax) syntax would you use to bring back those records? I'm using sql passthru.
>
>Thanks

The easiest way would be to use SQLEXEC parameters.

lcDateStart = {^2003/01/01}
lcDateEnd   = {^2003/01/10} + 1
lcSql = [SELECT * FROM mytable WHERE mydate >= ?lcDateStart AND mydate < ?lcDateEnd ]
? SqlExec(lnConn, lcSql, "aaa")