Subject SQL SELECT problem
Author Philip A. Stephens
The following statement works in IBAccess EXEC-SQL but fails in IBOConsole
or in My Delphi 5 App using an IBOQuery against Firebird 1.0.

'SELECT FIRST 10 * FROM FCDX_ZONES WHERE ADDRESS CONTAINING '01-' ORDER BY
ADDRESS'

I am new to Firebird and cannot find any indication of problems with the
query in the docs BTW

'SELECT * FROM FCDX_ZONES WHERE ADDRESS CONTAINING '01-' ORDER BY ADDRESS'

Works fine in all cases.


TIA -Phil Stephens