Thanks for the quick reply. That's useful to know - never used CASE before in SQL.

What I was ideally trying to do was lookup the value in the ProductType...