oblomov86 - That's what I am doing at the moment i.e. many different SQL Commands with parameterised variables within many IF statements. I just wondered if there was any other way to simplify the whole procedure. I think I'll go down the SELECT CASE road...

Thanks for your help