That is helpful. I had a client claim that they needed to use a SELECT to set a value within a stored proc, or was it a user defined function? Anyway, I was curious if the rules did vary at all depending upon where the variable value setting was being done. Thanks!