and what "substring" UDF are you using? If you are using FreeUDF, then you'd
need F_MID, no substring
Alan

-----Original Message-----
From: Jack Cane [mailto:jwcane@...]
Sent: Saturday, 21 December 2002 1:33 PM
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




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



Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/