Was the text column changed?

[Kristofer Gafvert]

I have a trigger on update, but i need to know if a specified column of the
data type TEXT was changed or not. Since it's TEXT, i cannot use '=', so,
is there any other way to do this?

Thanks!

--
Regards,
Kristofer Gafvert
[url]http://www.ilopia.com[/url] - Useful help for Windows Server 2003
Reply only to newsgroup(s), if you by some reason must contact me, remember
to remove the "online" part of my address.

[David Browne]

"Kristofer Gafvert" <kgafvertONLINE@ilopia.com> wrote in message
news:OUloRlXQDHA.3796@tk2msftngp13.phx.gbl...

> I have a trigger on update, but i need to know if a specified column of

the

> data type TEXT was changed or not. Since it's TEXT, i cannot use '=', so,
> is there any other way to do this?
>
> Thanks!
>

First check if the column was even updated with UPDATE(column).
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
results.

David

[Kristofer Gafvert]

Thanks!

--
Regards,
Kristofer Gafvert
[url]http://www.ilopia.com[/url] - Useful help for Windows Server 2003
Reply only to newsgroup(s), if you by some reason must contact me, remember
to remove the "online" part of my address.


"David Browne" <davidbaxterbrowne no potted [email]meat@hotmail.com[/email]> wrote in
message news:#VD9L$XQDHA.4024@tk2msftngp13.phx.gbl...

>
> "Kristofer Gafvert" <kgafvertONLINE@ilopia.com> wrote in message
> news:OUloRlXQDHA.3796@tk2msftngp13.phx.gbl...

> > I have a trigger on update, but i need to know if a specified column of

> the

> > data type TEXT was changed or not. Since it's TEXT, i cannot use '=',

so,

> > is there any other way to do this?
> >
> > Thanks!
> >

> First check if the column was even updated with UPDATE(column).
> 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
> results.
>
> David
>
>