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!