Hi,

I am using SQL Server 2000 and I have a table with a date field created with the type datetime. Physically, the field is with the '/' separator. For example, 9/10/01 10:24:55AM. When I execute a Select statement in Query Analyzer, I find that it changes to '-' separation (09-10-2001 10:24:55AM). With ADO, the returned values is '/' separated. When I try to update the record with ADO, using the '/' separator, it is not allowing me to update the record. For example, when I execute the following query :
Update TableId Set Field1 = '1' where Date = '09/10/01 10:24:55AM'

it is not updating the record saying that the record is not found.

Can anyone help me with resolving this issue.

Thanks,
Anitha