[thelist] SQL Equivalent to Access Specific Syntax

Rob Smith rob.smith at THERMON.com
Thu Sep 4 10:26:59 CDT 2003


What would be the SQL equivalent to this?

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

... I think would be?

lengthsmore225 = CASE WHEN [Footage]>=200 THEN CASE WHEN ([AllocatedBy] Is
Null) THEN [footage] ELSE 0 END ELSE 0 END

Yes?




More information about the thelist mailing list