Hi Kevin

>But honestly, you could get away with not using the LOCAL. The variable will still
>drop out of scope. Not appropriate, IMHO, but it would work.

Not necessarily. A variable is private by default. If it was declared in a calling method, it would not go out of scope upon exiting the called routine and your settings would not be reset.

>Seems to me your coming up with fuzzy reasons to knock this method. If it doesn't work
>for you, so be it. But I get cleaner code with one line instead of the multiple lines
>needed to Set & Reset SET statements.

I didn't see David's responses as knocking your method. In fact using his methods in combination with yours seems like the best solution.