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. :eek:
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