[thelist] SQL Equivalent to Access Specific Syntax

[Rob Smith]

Hi,

I'm smack dab in the middle of upgrading an Access 97 database and like
Microsoft, it does many things that no one else does. For example, in Access
you have the IIF statement:

IIf([Footage]>=200,IIf([AllocatedBy] Is Null,[footage],0),0) AS
lengthsmore225

What would be the SQL equivalent to this?

Rob.Smith