Thanks a lot. This works. I've pasted it in through the properties window.

Bollocks that you can't do it the easy way though through the GUI

Yes but Case is not allowed in the query designer either