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 |
|
baze7
Yak Posting Veteran
58 Posts |
 Posted - 2010-03-17 : 14:18:15
|
| I have 2 fields, description and notes. Line 1 of the notes field contains the info from the description field. The notes field could have mupltiple lines of other text. I want to delete the exact text out of the notes field where it matches the description field. They are almost always the only text on line 1 of the notes field. Any ideas? |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2010-03-17 : 14:54:54
|
replace(notes,description,'')
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
|
|
|
Comparing / Deleting