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

Steve

In article <5.1.0.14.0.20020206103156.04542c70@...>,
helebor@... says...

> At 04:32 PM 05-02-02 +0000, you wrote:
> >I know this isn't, strictly, an IBObjects question, but it does involve
> >the use of IBOQueries. I have an application written in Delphi6 using
> >data residing on a MySQL server which I am porting over to Firebase RC2.
> >The query is in the form:
> >
> >SELECT count(*) AS SL
> >FROM logins
> >WHERE server=DefaultServer AND
> >left(login,10) = ":Search1" AND
> >left(login,10) = "left(logout,10)" AND
> >acctype="S"
>
> Firebird has an internal SUBSTRING function:
>
> select ...
> SUBSTRING(login, 1 for 10) is the equivalent of your left(login, 10)
>
> regards,
> Helen
>
>
> All for Open and Open for All
> Firebird Open SQL Database � http://firebirdsql.org
> _______________________________________________________
>
>
>
> ___________________________________________________________________________
> 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.