Convert Excel function to SQL

Please state your requirements in a few sentences :)

vdr - your basic structure will be as follows.  From your previous question, I think you have a sense of how to write the SQL, you just needed the structure.  Your Excel expression has 6 conditions to test and that's reflected in the structure below.  Have a look and let me know us know if you need more detailed assistance.

IF ( Boolean_expression1 )
  BEGIN
    Sql Statement Block
  END
ELSE
  BEGIN
    IF ( Boolean_expression2 )
      BEGIN
        Sql Statement Block
      END
    ELSE
      BEGIN
        IF ( Boolean_expression3 )
          BEGIN
            Sql Statement Block
          END
        ELSE
          BEGIN
            IF ( Boolean_expression4 )
              BEGIN
                Sql Statement Block
              END
            ELSE
              BEGIN
                IF ( Boolean_expression5 )
                  BEGIN
                    Sql Statement Block
                  END
                ELSE
                  BEGIN
                    IF ( Boolean_expression6 )
                      BEGIN
                        Sql Statement Block
                      END
                    ELSE
                      BEGIN
                        Sql Statement Block
                      END
                  END
              END
           END            
      END
  END

Previous Question: If Expression in Excel

To put this into context of your previous question:

Boolean Expression1 (BE1) is the equivalent of A: in the decision tree
Boolean Expression2 (BE2) = B:
BE3 = C:
BE4 = D:
BE5 = E:
BE6 = F:

Also, you'll need to use SUBSTRING() instead of MID():  MSDN SUBSTRING()

Rather than sifting through a bunch of excel functions, can you just state the criteria in English?

Thanks again Mark for trying to put this together.. but i wanted to do this using CASE rather than IF as you will not be able to implement IF in an Inline statement

Thanks acperkins... this is exactly what i was looking for.. I will test it and let you know

No worries, vdr.  Hope ac's solution works for you.

aikimark, I did try negating the conditions but ran into a snag and thought it would not work.. but you proved me wrong... Thanks

Thank you guys..