Re: (Maybe) Silly question

On Friday 03 May 2002 16:19, Cal Evans wrote: > 4 step process > > ALTER TABLE to add a new Date column > > Populate the new field with the date portion of the DATETIME > > Drop the DATETIME column > > Rename the DATE column with the name of the original field. > Thanks. I'll try it. > -

RE: (Maybe) Silly question

4 step process ALTER TABLE to add a new Date column Populate the new field with the date portion of the DATETIME Drop the DATETIME column Rename the DATE column with the name of the original field. =C= * * Cal Evans * Journeyman Programmer * Techno-Mage * http://www.calevans.com * -Ori