I have to 3 parameters in picture.. state, city and emp name...
i have to create a query to perform search on the basis of values provided for eg: if no value is provided for State parameter but value is provided for other two parameters than i.e city and emp name than result from db should be returned on the basis of this combination(null value for state parameter should not be considered....
i.e query should return result for combination of city and emp only and NOT city, employee and null...
Same for other situation where maybe just state value is provided not the other two...