Dynamic column in select

[Christine Kurek]

I have a datawindow which I pass a string into. THe string that I
pass in is a column name. Is there a way in PB that I can create
something like

select :ret_colname
from mytable;

and the select statement actually brings back in the data in the
column that is referenced by that string?

eg:

:ret_colname = 'fname'

mytable has the following columns
fname
lname

I want the select to pull the same data as the following would:

select fname
from mytable;

if :ret_colname = 'lname' the select would change accordingly.

How can I do this in PB?

Thanks