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 |
|
fahad_001
Starting Member
11 Posts |
 Posted - 2008-03-24 : 04:11:50
|
| HiI have a table column with datatype text.This coulmn contains values likethis is sample, text , etc...this is sample, text , etc...this is sample, text , etc...Now i want to replace , with "br" tag, at every place where comma comes.i have write this query updatetext coulmname set columnname=replace(columnma, "," ,"<br>")but it gives error. Can any any one solve my problem how to replace , with br using updatetext?ThanksThanks |
|
|
Koji Matsumura
Posting Yak Master
141 Posts |
Posted - 2008-03-24 : 05:01:25
|
| use Single Quote |
 |
|
|
|
|
|
How to replace Comma with br using updatetext