Subject RE: [ib-support] SQL Error
Author Alan McDonald
and what "substring" UDF are you using? If you are using FreeUDF, then you'd
need F_MID, no substring

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


To unsubscribe from this group, send an email to:

Your use of Yahoo! Groups is subject to