• noel.moore - Friday, February 9, 2018 8:27 PM

    Thank you.  Certainly a step forward!   I still have an error---
    with 3 variations, I have errors.......
      AND (PAreaRaponi < 4.34
       OR [PAreaRaponi] > 4.66)
     AND (PAreaRaponi) > 1.0
    , 'is One/2/3/14','? ' ) AS "FlagA"
    Msg 207, Level 16, State 1, Line 16
    Invalid column name 'PAreaRaponi'.
    Msg 207, Level 16, State 1, Line 17
    Invalid column name 'PAreaRaponi'.
    Msg 207, Level 16, State 1, Line 18
    Invalid column name 'PAreaRaponi'

    Are you able to help again.  Thanks

    It's your database.  I have no idea what PAreaRaponi means.

    Drew

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA