Hi,

> Pseudo code:
>
> declare field varchar( 20 );
>
> if ( :question = 'y' ) then field='Field1';
> if ( :question = 'n' ) then field='Field2';
>
> select :field from Table_a where Field2 = '1' into :answer.
>
> Please can anyone tell me how to do this???

Take a look at EXECUTE STATEMENT in the Firebird
1.5 release notes.

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com