Hi All.

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

TIA
Arn