SELECT * FROM T WHERE HasAmount AND ( Amount = 10 OR NOT (Amount = 10) ) #### SELECT * FROM T WHERE NOT IsNULL(Amount) AND ( Amount = 10 OR NOT (Amount = 10) )