In article <5.1.0.14.0.20020206213448.05601230@...>,
helebor@... says...

> 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.

VB??? Never touch the stuff!

>
> 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
>
>
>
> ___________________________________________________________________________
> IB Objects - direct, complete, custom connectivity to Firebird or InterBase
> without the need for BDE, ODBC or any other layer.
> ___________________________________________________________________________
> http://www.ibobjects.com - your IBO community resource for Tech Info papers,
> keyword-searchable FAQ, community code contributions and more !
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>
>

--
Steve Lee-Woolf
University of Salford
Manchester, U.K.