sqlfriends (7/24/2013)
I would like use case statement in select .for example, if rate =100, then 1, if it is null, then 1, and if it is <>100, it is 0,how to write the select case statement in best way?
Thanks
SELECT
(CASE
WHEN rate IS NULL THEN 1
WHEN rate = 100 THEN 1
WHEN rate <> 100 THEN 0
END)
AS RateCode