If this has been answered, I somehow missed the reply. Would very much like
to get some help with the below problem.

tks,

jwc

-----Original Message-----
From: Jack Cane [mailto:jwcane@...]
Sent: Saturday, December 21, 2002 8:06 AM
To: ib-support@yahoogroups.com
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
pointer.

Happy holidays,

jwc



Yahoo! Groups Sponsor
ADVERTISEMENT




To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com



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


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