mysql to mssql query

[DevList]

Does anybody know the equivalent of this query in mssql:

SELECT * FROM myTable WHERE date_field >= DATE_SUB('2003-10-19', INTERVAL 7
DAY);

For this project we are pulling records off a MS SQL db, and I need to
figure a way to return all records for the week.

Any help is appreciated.




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]