Hi, I have this problem with a declared variable in a trigger. The variable is used to pass to a stored procedure which compiles a concatenated list. This works fine, until.. the trigger is fired by a multiple record operation - such as a multiple update. When this happens, the trigger is fired for each record as one would expect, but, bizarrely, the variable is not reset each time, and so the concatenated list continues to grow at every iteration of the trigger for each of the records. There does not appear to be any way of resetting the string variable; you can&#039t set it to null, spaces or anything else and have it behave as a new variable. This is driving me insane. Any ideas?