? embed scalars in the sql

[Francesco Scaglioni]

Hi,

Is it possible to embed a scalar into the sql such that the value of
the scalar could represent a column name to report or a value to
select by

eg something to mean the following

select $column_name from test where $another_column_name =
$column_value

or even better:

count rows where $column_name = $column_name_value and $another_column
= $another_column_value


If I am making myself clear?

TIA

Francesco