Thank you Christopher and Chris. I went with Chris' solution and it worked like a charm. NICE!

Christopher Stobbs (3/18/2009)

---

try this:

CREATE VIEW AS mynewview

SELECT a.col1,a.col2,b.col3,b.col4,b.col5,

colMask =

CASE

WHEN ((b.col3 % 8) /4) >= 1 --'Submit'

THEN CASE

WHEN ((b.col3 % 16) /8) >= 1 --'Modify'

THEN 'Submit,Modify'

ELSE...