Help to convert Access IF statement to sql

[Nancyade]

can anyone help to convert the below access if statement to sql?


Response Time: IIf([Referral Acknowledged ]="0","Yes on Target",IIf([Referral Acknowledged ]="1","Yes on Target",IIf([Referral Acknowledged ]="2","Yes on Target",IIf([Referral Acknowledged ]="3","Yes on Target",IIf([Referral Acknowledged ]="4","Yes on Target",IIf([Referral Acknowledged ]>" 2","No not on Target",IIf([Referral Acknowledged ] Is Null Or [Referral Acknowledged ]=" "," Blank No Document Upload")))))))

 

[pbaldy]

Look in BOL at the CASE statement. If you're not familiar with it, BOL is Books Online, which should have been installed with SQL Server. It is SQL Server's help system, and is pretty comprehensive.