As a certain Mr Simpson would say - Doh!

Thanks for your help!!

I tried this but got an error:-

Error: Incorrect syntax near the keyword 'CASE'. (State:37000, Native Code: 9C)

Any ideas why?

Thanks Guys - both proved very useful!