>>>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.