Case Statement

[rstum2005]

If you were to want the ELSE [return value] to not show up at all what would you do?

any tips?



CASE [expression]
WHEN [value | Boolean expression] THEN [return value]
[ELSE [return value]]
END





"Success consists of going from failure to failure without loss of enthusiasm."
Winston Churchill~

 

[checkai]

something has to show up in the column...

case when column=1 then column else NULL end

not sure what you're wanting...

"...we both know I'm training to become a cagefighter...see what happens if you try 'n hit me..."

 

[rstum2005]

Id like every row with the NULL in it to not show up in the results.

Thanks

"Success consists of going from failure to failure without loss of enthusiasm."
Winston Churchill~

 

[checkai]

then I would put your case criteria in the where clause...

"...we both know I'm training to become a cagefighter...see what happens if you try 'n hit me..."

 

[SQLDenis]

select * from table where field is not null

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[rstum2005]

let me rephrase.

(SELECT top 100 percent
'radius' = case when cast(t2.radius as numeric(10,0)) between 0 and 100 then '0 to 100' 
else null
end

results-

radius field field field
NULL 10004753 0 0

I dont want this to show in my results
I already have tried adding radius is not null to my where clause.

"Success consists of going from failure to failure without loss of enthusiasm."
Winston Churchill~

 

[SQLDenis]

add
where cast(t2.radius as numeric(10,0)) between 0 and 100
and get rid of the case

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[rstum2005]

i only posted a little fragment of the code so i could not do that.

"Success consists of going from failure to failure without loss of enthusiasm."
Winston Churchill~

 

[rstum2005]

I figured it out..

it was pulling -1 radius fields and placed the null in there so I just added "where radius > '-1'" in the where clause

Thanks for all the responses.

"Success consists of going from failure to failure without loss of enthusiasm."
Winston Churchill~