Sergey

Thanks that was great!

Jim


>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>