Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 compare content & data

Author  Topic 

LearnSQL
Starting Member

12 Posts

Posted - 2001-08-23 : 07:47:07
Hi all!

You have been very helpful answering a question for me in the past. Unfortunately, I have another problem...

Is there a way to compare content in a field of a table?

For example,
table1.content column contains:
"I have an appointment."
table2.content column contains:
"I have two appointemnts."

I would like to pick out "two"/"an" and "s" when comparing two data. We are trying to achieve something similar to MS Word tracking change (strike-through & underline) option feature in our application except ours will be in dynmaic web application where each section will come from table columns/rows.

BTW, some columns are in text datatype.

Is there way to resolve/achieve this?

Any help you can give me will be greatly appreciated!

Thank you!



   

- Advertisement -