Hi, can i ask some help,How can i do this in my sql query to have Case statement?
Example in my employee table i want to have case statement on my empno.
select * from employee
case
when empno = "000070" then firstname = "Jack"
when empno = "000050" then firstnmae = "Stellar"
when empno = "000030" then firstname = "Sheek"
else firstname = "jemz"
end
can you help me please i am confuse in my querry.

Thank you in advance.