"Kristofer Gafvert" <kgafvertONLINEilopia.com> wrote in message
news:OUloRlXQDHA.3796tk2msftngp13.phx.gbl...the> I have a trigger on update, but i need to know if a specified column ofFirst check if the column was even updated with UPDATE(column).> data type TEXT was changed or not. Since it's TEXT, i cannot use '=', so,
> is there any other way to do this?
Then check the datalength(), if that's different, it changed.
If the column was updated and the datalength is the same, then you must read
through it 8000 characters at a time using substring() and compare the