Subject FW: [ib-support] SQL Error
Author Jack Cane
If this has been answered, I somehow missed the reply. Would very much like
to get some help with the below problem.



-----Original Message-----
From: Jack Cane [mailto:jwcane@...]
Sent: Saturday, December 21, 2002 8:06 AM
Subject: [ib-support] SQL Error

I am having trouble with the following update query on an IB table:

update membernames
set username =
concat( substring( firstname, 1, 1 ),
substring( lastname, 1, 7 ))
where mbrnr = 1;

This gives Error -104 at the comma after firstname.

Any hints appreciated. I used Oracle's SQL reference for the concat syntax.
I also tried the || operator.

If there is a better SQL reference for use with IB I would appreciate a

Happy holidays,


Yahoo! Groups Sponsor

To unsubscribe from this group, send an email to:

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

[Non-text portions of this message have been removed]