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
_______________________________________________________