After reading all the stuff I can find on dynamic SQL I aggree that using it is a "bad thing". However, the stored proc I'm currently writing would be...

Thanks - the CASE solution works a treat...

And thanks also for the link to dynamic SQL - I've been looking for a way to build storedprocs on the fly and...