I've been forced to take over a .asp report page that pulls data from MSSQL.The table I'm pulling data from has a field which is of the SQL datetime data type. I want to display this value as text ...

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 ...