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!