Excellent, thanks. I was unaware of this feature in mysql. (I tend to be more of an oracle sql user than anything else, though I use mysql as a 'staging' area before code is released.) I'll use this in the future.