SQL server will accept datetime strings in more or less any sensible format for the purposes of comparison.<BR><BR>select * from employee<BR>where hire_date='1993-08-19'<BR><BR>select * from ...

The problem is that SQL Server won't find a result becuase it stores it's date in the format '2002-6-27 11:30:25.000 AM'.<BR><BR>My question is...is there any way to force SQL Server to ignore ...