Hi,

> Here is what I just tried. I get an error at the space after firstname.
> update MemberNames
> set username =
> SUBSTRING( firstname 1 FOR 1 ) ||
> SUBSTRING( lastname 1 FOR 7 );

The SUBSTRING syntax is

SUBSTRING(<expr> FROM <start_pos> [FOR <length>])


So this should work :

UPDATE MemberNames
SET username =
SUBSTRING( firstname FROM 1 FOR 1 ) ||
SUBSTRING( lastname FROM 1 FOR 7 );


Regards,
Arno Brinkman