SQL check if numrical value is 0 for a field where id is=333

Question

inside an SQL SELECT CASE STATEMENT how would i check if the a value for some coulmn in sometable is equal to 0 where the id is equal to something?

Can you post an example statement. The answers that involve a sub query inside the case statement will work, but are likely to perform poorly. There may be a better way to get your result. — Tobsey, Oct 19 '12 at 11:27

score 3 · Answer 1 · answered Oct 19 '12 at 11:25

3

select
    case
        when (select column_name from sometable where id = @id) = 0 then
        else 
    end

answered Oct 19 '12 at 11:25

Roman Pekar

score 2 · Answer 2 · answered Oct 19 '12 at 11:26

2

select 
 case when( select column from table where id=333)=0 then "your condition"
else
end

answered Oct 19 '12 at 11:26

SRIRAM

score 1 · Accepted Answer · answered Oct 19 '12 at 11:35

1

My interpretation of your question:

SQL check if numerical value is 0 for a field (Field1) [only] when id is=333
[If id is not 333, don't need to check]

SELECT CASE WHEN isnull(id,0) <> 333 OR Field1=0 THEN 1 ELSE 0 END
      ,other1, other2
  FROM tbl

answered Oct 19 '12 at 11:35

RichardTheKiwi

3 Answers3