sql server - Sql Query which filters according to one or more fields -

sql server - Sql Query which filters according to one or more fields -

sql query:

select * tabemployee city='delhi' or locality='' or pincode='' or salary between '' , '' or designation=''

i quite new sql server.

i want write sql query city mandatory , other fields may or may not provided user.

i mean if 1 user enters locality='kirti nagar'.

filter should work according city='delhi' , locality='kirti nagar'.

in other case, user may come in salary range.

then filter should work according city='delhi' , salary between 5000 , 10000.

if user doesn't come in field filter should work according city='delhi' only.

how can ?

try this:

select * tabemployee city='delhi' , isnull(locality_parameter,locality)=locality , (pincode=pincode_parameter or pincode_parameter=0) , isnull(designation_parameter ,designation)=designation , salary between isnull(lower,salary) , isnull(upper,salary)

set pincode_parameter=0 when user doesn't come in pincode

sql sql-server