Jason,
You can use the macro operator '&' for that.
Example

cfield = 'MYFIELD'
select * from mytable where &cfield = ?cValue