How can i use if statement within case statement in sql?

Hi

Check the code

SELECT CASE
 WHEN -1 < 1 THEN 'TRUE'
 ELSE 'FALSE' END AS Result
 GO

-- SQL Server 2012 solution
 SELECT IIF ( -1 < 1, 'TRUE', 'FALSE' ) AS Result;
 GO

For detail check hte links

http://blog.sqlauthority.com/2013/11/04/sql-server-implementing-if-then-in-sql-server-with-case-statements/

http://stackoverflow.com/questions/13991247/how-to-perform-multiple-if-statement-inside-case-statement-of-sql-server

http://stackoverflow.com/questions/14537871/if-condition-inside-case

0

Below Query can help you....

-------------------------------------------------

declare @userName varchar(10)='Nirav';

select CASE @userName

WHEN 'Nirav' THEN '[email protected]'

WHEN 'Jayes' THEN '[email protected]'

WHEN 'Rahul' THEN '[email protected]'

ELSE 'No User Found'

END as Email

0

i would not prefer it but here is the code

http://www.asadalimirza.com/2016/06/using-a-if-within-switch/

Please mark the question answered if you got your reply

0