Hi!,
> From: W [mailto:[EMAIL PROTECTED]]
> Sent: 04 October 2002 15:11
> To: [EMAIL PROTECTED]
> Subject: Question Regarding Update Year statement
> I'm looking for a date function that will allow me to update only the year
> portion of a field to a particular y
Hello All,
I'm looking for a date function that will allow me to update only the year
portion of a field to a particular year, in this case, 2002.
I've tried "UPDATE [table] SET YEAR([field]) = '2002' WHERE [field] > 2002"
but this gives me an error. The MySQL documentation only seems to cover
