Hi,

I need to change a varchar field in my DB to a small date/time field. The problem is I don't want to lose the data, as I have quite a lot of records. Is there a way I can convert the varchar into a date?

TIA

You might try ADDING a small date/time field to the same table, then do an update query to basically copy the data from your varchar field to the small date/time field, and then delete the varchar field.

Alternatively, you could use DTS to move the data over to a new table with the same format, except for the one field's data type.

HTH


mmcdonal

Thanks