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

Question

Hi everyone i want use if condition within case statement so how can i use?

Vinay Singh · Answer

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

Nirav Daraniya · Answer

Below Query can help you.... ------------------------------------------------- declare @userName varchar(10)='Nirav'; select CASE @userName WHEN 'Nirav' THEN 'nirav@gmail.com' WHEN 'Jayes' THEN 'jayesh@gmail.com' WHEN 'Rahul' THEN 'Rahul@gmail.com' ELSE 'No User Found' END as Email

Asad Ali · Answer

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