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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-04-02 : 08:57:29
|
| Michael writes "I´m now sitting some days @ a problem I´m not able to solve.I have a producttable with a row for "partnumber" and a row for a detailed discription "detail" .within the string of "detail" there might be some references to other partnumbers like "use CAM 151 for yello".what i now want to do is put some HTML around this partnumber IF this partnumber is also within the product table itself.So for this example the result should look like "use <pB>CAM 151</pB> for yello".There also might be more than one reference within the "detail" string.My idear to solve this is to use REPLACE for every partnumber in the product table.But I not clever enougth to do this.Please help. Michael" |
|
|
graz
Chief SQLTeam Crack Dealer
4149 Posts |
Posted - 2002-04-02 : 08:57:29
|
| We wrote an article on using replace in an update statement: http://www.sqlteam.com/item.asp?ItemID=7386 |
 |
|
|
|
|
|
Replace