How to use an IFF in the SELECT clause 1

[bartdedecker]

Hi,

How can I use an IFF in my select clause.
I have a column VAT_NUMBER (nvarchar(50)) in my Table. I want an extra column in the result of my query. If the VAT_NUMBER is not null then return 1 otherwise return a 0.
(I use SQL Server 2000)

SELECT 
   NAME,VAT_NUMBER, ???VAT_NUMBER_YN???
FROM 
   USERS

Thx in advance

 

[r937]

select NAME
     , VAT_NUMBER
     , case when VAT_NUMBER is null
            then 0 else 1 
          end as  VAT_NUMBER_YN
  from USERS

rudy | r937.com | Ask the Expert | Premium SQL Articles
SQL for Database-Driven Web Sites (next course starts May 8 2005)

 

[spangeman]

What about the isNull function ????