Subject Re: [IBO] Firebird newbie
Author Helen Borrie
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

Firebird has an internal SUBSTRING function:

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


All for Open and Open for All
Firebird Open SQL Database ยท