>>Hi Dan,
>>
>>Yep, that'll happen. It's once of the reasons why I never, ever make modifications to incoming parameters, regardless if it's a procedure or a function, unless it's the express intent of the program code to do so.
>
>That's true. My tendency has always been to store the parameter to a local variable, if I wanted to change it. I had forgotten why I was doing that, but that's definitely the reason.

For me, all it took was one instance where an assumption on my part led to problems. As you know, by default UDFPARMS is set to VALUE. I ran into a case where, unbeknownst to me, in someone else's code I was working on, this was changed to REFERENCE. Can you say, "KA-BOOM", boys and girls? I thought you could.:-)

Needless to say, from that day forward, I always assign incoming variables to local ones where modification is necessary.