Hi,
I am trying to update a field so that it retains its contents plus the
contents of another column like this:
UPDATE MyTable SET Comments = CONCAT(Comments, 'Old_ID_Field = ',
Old_ID_Field) WHERE Table_ID = 1;
However I just get a blank Comments field, any ideas why this is happening?
Than
"Shaun" <[EMAIL PROTECTED]> wrote on 01/18/2006 10:57:49 AM:
> Hi,
>
> I am trying to update a field so that it retains its contents plus the
> contents of another column like this:
>
> UPDATE MyTable SET Comments = CONCAT(Comments, 'Old_ID_Field = ',
> Old_ID_Field) WHERE Table_ID = 1;
>
> H
