Thanks for your replies. Yes, I agree SET DATE FORMAT will work as well. But you need to know the date format your client application is sending to SQL.

We...

We struggled some month with an application used in international environments. The problems are caused by date queries.

SQL 2000 interprets dates depending on the language of the server, the language...