>>>Hi,
>>>I would like to create a SQL Server command that would set a column to a value and at the same time set the value before the change.
>>>
>>Look into OUTPUT clause for UPDATE command in order to set variables of before and after values (Deleted and Inserted tables).
>
>Did you see what Hugo suggested? And thank you for your suggestions.
I saw it, but it's not a good suggestion. OUTPUT clause is the way to go.
If it's not broken, fix it until it is.
My Blog