Please Help For case Syntax for null

Question

0.00/5 (No votes)

See more:

I am tring to get output as aaa if coloumn is null but every time i get anser as as empty coloumn

SQL

select
CASE WHEN s.THEORY =null
then 'aaa'
end 
from TBL_MARKS s

Posted 7-Apr-13 21:48pm

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Aarti Meswania · Answer 1 · 2013-04-07T21:54:00

SQL

select
CASE WHEN s.THEORY IS null
then 'aaa'
else 'bbb'
end as col1
from TBL_MARKS s

Happy Coding!
:)

Posted 7-Apr-13 21:54pm

Comments

Member-515487 8-Apr-13 3:57am

no bro its giving me Empty coloumn

Aarti Meswania 8-Apr-13 4:01am

select case when len(isnull(s.theory,''))=0 then
'aaa'
else
'bbb'
end as col1
from tbl_marks s

Member-515487 8-Apr-13 4:01am

if not exists(select
CASE WHEN s.THEORY IS null
then 'aaa'
else 'bbb'
end as col1
from TBL_MARKS s)
begin
select '1'
end

giving 1 as output