Help for this page

Select Code to Download

Select or download this

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

Select or download this

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