Обсуждение: Append text using Concat on an Update query

I'm trying to append new text on a field using the concat function.

On the Set statement I use something like this:

Set Field = Concat(Field,'ABC')

And when I check the results 'ABC' wasn't appended to <Field>.  What
should I do to make it append?

On Thu, Feb 01, 2007 at 05:03:43PM -0800, d wrote:
> I'm trying to append new text on a field using the concat function.
>
> On the Set statement I use something like this:
>
> Set Field = Concat(Field,'ABC')

> And when I check the results 'ABC' wasn't appended to <Field>.  What
> should I do to make it append?

The SQL standard syntax for this is,

    Set Field = Field || 'ABC'

Cheers,
David.
--
David Fetter <david@fetter.org> http://fetter.org/
phone: +1 415 235 3778        AIM: dfetter666
                              Skype: davidfetter

Remember to vote!