Hi Peter,

> 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"

Is your database a "dialect 3" database?

Martijn Tonies
Database Workbench - development tool for Firebird and more!
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com