> This results in the error message, > "Cannot convert a DATE value to a DATETIME value."
That's a surprise! Could you do: ALTER TABLE Table ADD COLUMN NewColumn DATETIME UPDATE Table SET NewColumn = (DATETIME(OldColumn, '0:00 pm')) ALTER TABLE DROP COLUMN OldColumn ALTER TABLE ALTER COLUMN NewColumn TO OldColumn DATETIME You'd have to fiddle with the format of the time in the DATETIME function. -- Larry
