At 05:00 PM 19/04/2007, you wrote:

>Thanks Helen.
>
>Sorry about the non-plain text message before.
>
>How do i do this kind of query when using the Firebird ISQL Tool?
>
>I get this error for the following query:
>
>SQL> select subu_name As "Suburb Name" from suburb where subu_id = 2000;
>Statement failed, SQLCODE = -104
>Dynamic SQL Error
>-SQL error code = -104
>-Token unknown - line 1, column 21
>-"Suburb Name"

That seems to suggest this is an old dialect 1 database...IB 5.x
maybe? or just a dialect 1 db created by mistake, perhaps...

./heLen