Using an if statement

[chudson007@hotmail.com]

I have a column in a table... ColumnA
ColumnA contains positive and negative numbers
What I want to do is insert an expression that basically does the
equivalent of the following excel formula..

If(ColumnA>=0," Use","Ignore")

What should I change the following syntax to?

SELECT *, ColumnA AS Expr1
FROM Table

Regards,
Ciarán

[David Portas]

Re: Using an if statement

SELECT *,
CASE WHEN columnA>=0 THEN 'Use' ELSE 'Ignore' END AS expr1
FROM Table

--
David Portas
SQL Server MVP
--

[Simon Hayes]

Re: Using an if statement

You're probably looking for CASE (see Books Online):

select case when ColumnA >= 0 then 'Use' else 'Ignore' end as 'Expr1'
from dbo.MyTable

Simon