At 10:34 AM 06-02-02 +0000, you wrote:

>Thanks Helen. Its a bit arcane in it's syntax isn't it?
>
>Steve

Actually, what I quote was a bit arcane, since I omitted the keyword FROM:

I said:

> SUBSTRING(login, 1 for 10) is the equivalent of your left(login, 10)

I should have said:
SUBSTRING(login FROM 1 FOR 10) is the equivalent of your left(login, 10)

Arcane as it might be to the VB programmer, Steve, it is the SQL standard.

cheers,
Helen


regards,
Helen Borrie (TeamIBO Support)

** Please don't email your support questions privately **
Ask on the list and everyone benefits
Don't forget the IB Objects online FAQ - link from any page at www.ibobjects.com