>You have to use macro substitution in this case

lcFieldname = "firstanme"
>lcSomeVar = "a"
>select &lcFieldname ;
>  from testdata ;
>  where &lcFieldname == lcSomeVar ;
>  into cursor test
>

>>how can I make a field that I want pick in sql statement generic. For example I can write the following sql statements
>>
>>select firstname from testdata into cursor test where firstname == a
>>select lastname from testdata into cursor test where lastname == b
>>select address from testdata into cursor test where address == c
>>
>>how can I make it so that the selection fields can substituted with a variable? for example
>>
>>select fieldname from testdata into cursor test where fieldname == somevariable
>>
>>I want to be able to choose my own fieldnames.
>>
>>Thanks
>>Nick Patel


Thanks Sergey, it work like a charm.

Nick