Load Script If statement causes ODBC error...?

[#1]

Hi everyone,

Would anyone be able to offer a reason or solution to how an If statement causes an ODBC error.

............

      ,if(NOT(ISNULL(MedicalComplaint)) AND NOT(ISNULL(TraumaComplaint)),MedicalComplaint & ',' & TraumaComplaint,

        if(ISNULL(MedicalComplaint) AND NOT(ISNULL(TraumaComplaint)),TraumaComplaint,

          if(NOT(ISNULL(MedicalComplaint)) AND ISNULL(TraumaComplaint),MedicalComplaint))) as ChiefComplaint

However this one works, the only difference being the last line is ommitted.

..........

      ,if(NOT(ISNULL(MedicalComplaint)) AND NOT(ISNULL(TraumaComplaint)),MedicalComplaint & ',' & TraumaComplaint,

        if(ISNULL(MedicalComplaint) AND NOT(ISNULL(TraumaComplaint)),TraumaComplaint)) as ChiefComplaint

Many thanks in advance

[danielrozental]

Try posting the entire sentence. What vendor database are you trying? SQL Server?