Mister Magoo...your solution worked for my simple select statement..thank you !

..BUT, when I add a case statement to the select statement, it stops working...any idea why ?

or any other solutions out there ?

thank you for your help, as I really need to nail this down.