any one help me for the case of "case statement"

[jobinjee]

i use the case statement but it always show that an error near the case....

my usage is

select category =
case
when qtysold is 12 then 'sorry'
--when 'Band' then 'Wrist Band'
--when 'eyering' then 'eyring'
--when 'ear ring' then 'earring'
else qtysold
end
from mysales

[Jim Doherty]

i use the case statement but it always show that an error near the case....

my usage is

select category =
case
when qtysold is 12 then 'sorry'
--when 'Band' then 'Wrist Band'
--when 'eyering' then 'eyring'
--when 'ear ring' then 'earring'
else qtysold
end
from mysales

try

when qtysold is = 12 then 'sorry'

[iburyak]

Try this:

select category = 
case 
when qtysold = 12 then 'sorry'
--when ? = 'Band' then 'Wrist Band'
--when ? = 'eyering' then 'eyring'
--when ? = 'ear ring' then 'earring'
else qtysold
end
from mysales