I need to develop a search application in which the user can select from the existing list of drop downs. The user should be given a provision to select either one of the drop downs or a combination of drop downs. I am developing this application using servlets. Can anybody please let me know the sql string which will enable the user to search based on one or combination of drop down columns.
Thanks for ur response. I tried using OR and Like's but the problem is I need to retrieve only those values which match that particular criteria. I have around 3 drop down boxes and the user can select either all 3 or can select only 2 of them or may be only one. In this kind of a scenario, only those values which match all 3 drop downs or all 2 drop downs or just that one drop down selection has to be retrieved. When I use OR...I am getting duplicate records.
Can you please let me know where am I going wrong.