Conditional Field in SELECT 2

[BoulderBum]

I want to do something like:

SELECT a, b, ( c ) AS d
FROM table

where "c" would be a conditional statement like:

IF x IS NOT NULL AND y IS NOT NULL
    C = 'yes'
ELSE
    C = 'no'

Is what I want to do possible? How do I do it?

 

[mwolf00]

try this...

SELECT a, b,
case
when x is not null and y is not null then 'yes'
else 'no'
FROM table

Programming today is a race between software engineers striving to build better and bigger idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning. - Rick Cook (No, I'm not Rick)

 

[Mdavis123]

You need a Case selection/substtution.
Select a,
b,
Case when x IS NOT NULL AND y IS NOT NULL
Then 'Yes'
Else 'No'
End As C,
D
From mytable

See BOL and CASE
MikeD

 

[mwolf00]

darn left off the "end"

SELECT a, b,
case
when x is not null and y is not null then 'yes'
else 'no'
end as C
FROM table

Programming today is a race between software engineers striving to build better and bigger idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning. - Rick Cook (No, I'm not Rick)

 

[BoulderBum]

Thanks, guys.