WHERE Clause with CASE WHEN....THEN....ELSE ... END with columns = > and IS NULL conditions

Going by your description I think what you need is this

SELECT     PriceRevID, PriceID, SourceID
FROM         dbo.PriceListRev
WHERE     SourceID = @intSourceID 
OR @intSourceID < 0

---

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