I am trying to build a SQL query on a table where I use a variable for the table fieldname in teh where clause e.g,
var1 VARCHAR(10) ;
var1 := '"FIELD1"';
select * from TABLE1 where :var1 = 'X' ;
It's not recognising var1 as FIELD1 from TABLE1, can anyone help?