Tricky IIF convert to T-SQL

[Schoofy]

Hi,

at first my question i not a pure SQL question. It's more between MS Access and T-SQL.

I have to upgrade an MS Access database to Sql Server. I found a statement in a Access query which drives me crazy.

IIf(Left([A_Extraktion_PIB_Split].[Produkt],3)<>"LLD",IIf([Produktkategorie]="MM",IIf(Not IsNull([T_MM_Handelsmarkierung].[MarkDate])

How can I convert it to SQL ? Normally I would use a CASE WHEN construct, but here I'm lost.

Thanks a lot.

Schoofy

[skhanal]

Is this nested IIF?. You can nest CASE upto 10 levels in SQL Server.