You're right, you can pass them by parameter name. Now assuming the parameter name is the same as the fieldname, things are a bit easier I agree.

Good, glad to hear you agree. I generate my stored procs from a data dictionary, and am able to generate parm names from column names.

OK, do you have any other responses?

Kevin