How to form 'select statement' based on user Search in BSP page...??

Hi Good evening to all...

I have BSP page that contain search Fields..If user enter some value in search fields, The 'SELECT' statement should form based on user input value..

ex:

user enter "Male" in Gender search field..The select statement should change like below..

SELECT * from ZDATABASEVIEW into data_table where ZCAND_GENDER = 'Male'.

similarly for some more fields...

Please any one suggest me how to proceed...

I already searched some sdn forum discussion but i didn't get what i need..

thanks and regards

santhosh..