| Subject | RE: [ib-support] SQL Error |
|---|---|
| Author | Helen Borrie |
| Post date | 2002-12-22T13:12:08Z |
At 07:39 AM 22-12-02 -0500, you wrote:
SUBSTRING( firstname FROM 1 FOR 1 ) ||
SUBSTRING( lastname FROM 1 FOR 7 )
heLen
>Here is what I just tried. I get an error at the space after firstname.Sorry, it's
>update MemberNames
>set username =
> SUBSTRING( firstname 1 FOR 1 ) ||
> SUBSTRING( lastname 1 FOR 7 );
SUBSTRING( firstname FROM 1 FOR 1 ) ||
SUBSTRING( lastname FROM 1 FOR 7 )
heLen