On Thu, May 22, 2003 at 10:38:54 -0500,
"Kovalcik, Mike A [ITS]" <mkoval01@sprintspectrum.com> wrote:
> Well....
>
> I set my table up like...
>
> Bday date
>
> Where bday is my column name and date is the data type....
>
> I've tried a lot of things to remove it, but I've had no luck:
>
> UPDATE address SET Bday = '' WHERE addressid = '4'
>
> This is when it gives me the error, but I'm not sure what else to put
> there to make sure it is in date format to remove the date completely...
If you are doing things this way then you probably want to use:
UPDATE address SET Bday = NULL WHERE addressid = '4'