Thanks for that. I didn't realise you could use dynamic sql that way. As a programmer it was drummed into me that dynamic sql was baaaaaad so I've avoided looking...