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.
| Author |
Topic |
|
germaine84
Starting Member
1 Post |
 Posted - 2012-03-06 : 14:51:11
|
| I have a form with many fields that will be entered into a database table from an aspx page. Once an entry is made, I want to create a script that takes what was entered in the comment field and search the table for matches. If a record matches 50% or more of the text, I want to calculate how much of the texts are similar and save that to a column in the database.For example: I have tblComment. It has 10 attributes and one column is named comment. Its a varchar field. After a new entry has been made into tblComment, I want to take the text in the comment field and search the table for similar text. If a match of 50% or more is made, I want to update the comment's percent match field with the percentage. |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
|
|
|
Regular expression and percentage match