I agree that this should be done with stored procedures. It's to maintain a total of four environments (live, uat, sys-test and dev), so I was hoping to have the...

David,

What function is the 'SELECT NULL' performing at the beginning of your statement?

Thanks,

Andrew