For one column I need some logic, return null in select

[nikos101]

I have a query where I want to select stuff but for one column I need some logic

select a,b,c, { if (a=b ) return null, else return a - c} as d

I don't know how to do this,

Any ideas?

[Dan_Bracuk]

select case
when a = b then null
else a-c
end as d

[nikos101]

Worked a treat thanks

[nikos101]

Oh btw I'm trying some complex stuff but getting errors,can anyone see what's wrong with this:

declare @amount float
set @amount = (
case when @b = 'B' then
(select SUM(a) from t ) else

(select SUM(c) from t)
)

[Dan_Bracuk]

my suggestion is to get your sql working first, and then put it into your sp.

[-__cfSearching__-]

> can anyone see what's wrong with this:

You are missing the case END