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?

When I try your query on PSQLV8.7 on a CHAR field, I get an error about
ther field being truncated.

To fix this, you have to trim the right side, as in this:
UPDATE TABLE
SET Field = CONCAT(RTRIM(Field),'ABC')

However, I made several assumptions:
1) You are running PSQLV8. Since there are numerous versions and
subversions, please remember to specify.
2) You are using a CHAR data type. If you are using VARCHAR or
LONGVARCHAR, the results may be very different.
3) You are getting an error like this. Again, if you have an error
message, please remember to specify it in your post.


If these assumptions are incorrect, please post more information.
Goldstar Software Inc.
Pervasive-based Products, Training & Services
Bill Bach
BillBach (AT) goldstarsoftware (DOT) com
http://www.goldstarsoftware.com
*** Chicago: Pervasive Service & Support Class - 03/2007 ***


datenisis wrote: