IIF Function

• mightyjoemad

  Mr or Mrs. 500

  Points: 586

  More actions

  September 25, 2003 at 7:01 am

  #107166

  I have Access SQL code that I need to transfer to SQL Server SQL. I have many IIF functions in the SQL. Can we use the IIF function from Access in SQL Server or do we have to use CASE or regular IF statements?

  Thanks

• SQLBill

  SSC Guru

  Points: 51440

  More actions

  September 25, 2003 at 7:56 am

  #475805

  There isn't any IIF in SQL Server. Use the CASE statement.

  -SQLBill

• EdH334

  SSCrazy

  Points: 2857

  More actions

  September 26, 2003 at 3:09 am

  #475936

  I have always found that for complex IIF(expression,truepart,falsepart) statements there is no real alternative but to convert to CASE WHEN expression THEN truepart ELSE falsepart END. However SQL Server does have some functions that work for simple criteria, e.g. ISNULL(expression, replacement), which is the equivalent of Access' Nz() with two argumants and NULLIF(expression1,expression2) which returns NULL if expression1 = expression2.

• sbalusa

  SSC Veteran

  Points: 276

  More actions

  September 26, 2003 at 12:35 pm

  #476067

  Similar reply like other did - Use CASE statement. Check out the link - Vyas has a nice example.

  http://vyaskn.tripod.com/programming_faq.htm#q2