Jim,

IF is not going to work in SELECT. You can use another form of CASE function.

CASE WHEN dbo.Made2ManageReport_v.passthrough = 'P'
  THEN 'PASS THROUGH' ELSE 'BACK TO BACK' END AS something

Also, I wouldn't recomend to use double quotes for string literals because it'll fail if SET QUOTED_IDENTIFIER is ON.

>Okay I enjoyed the case statement so much I tried an IF statement.
>
>can this work?
>
<snip>