how to compare data of text type?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

chemInformatic - 06 Dec 2005 12:23 GMT

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?

Reply to this Message

ML - 08 Dec 2005 10:11 GMT

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/

Reply to this Message

Hilary Cotter - 09 Dec 2005 19:01 GMT

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.

Signature

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

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

Reply to this Message