Filter rows based on Where condition AND-OR ?

something like below

WHERE (AddendumNo = @A1 OR @A1='')
AND (ClaimNo = @C1 OR @C1 = '')
AND Description = @D1 OR @D1 = '')

and in application set default value of textboxes as blank.

No need of dynamic sql

---

Please Mark This As Answer if it helps to solve the issue Visakh ---------------------------- http://ift.tt/19nLNVq http://ift.tt/1iEAj0c