>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

I just use the format returned from DTOS(). That seems to work fine for SQL2000.

SELECT * FROM table WHERE datetimefield BETWEEN '20030101' AND '20030110'