how to compare data of text type?

We can't use the term "=" to compare the data directly ,of which type
is text or ntext. Are there other good ideas to get the exact matchs?
In T-SQL you can use the LIKE operator without any wildcard characters.
However, you'd much better off using an appropriate text comparison tool on
the client.
ML
http://milambda.blogspot.com/
|||Do hierarchy of tests, first check datalength to see if they are the same,
if not bail stating difference, if they are, then you need to do byte by
byte comparisons.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"chemInformatic" <cdfuwu@.hotmail.com> wrote in message
news:1133871808.033165.299100@.g47g2000cwa.googlegr oups.com...
> We can't use the term "=" to compare the data directly ,of which type
> is text or ntext. Are there other good ideas to get the exact matchs?
>