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 |
|
mcp111
Starting Member
44 Posts |
 Posted - 2006-01-27 : 20:34:56
|
| I have control codes in the description field as shown below. I need to create a report of only code and description without the \rtf... etcIs there any way I can remove these from my final output using SQL?Any help is greatly appreciated.modcode longdescription lastupdate updateid ------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ------------------------------------------------------ --------------- 1 {\rtf1\ansi\deff0{\fonttbl{\f0\fnil\fcharset0 MS Sans Serif;}}\viewkind4\uc1\pard\lang1033\f0\fs17 A normal healthy patient\par } 2005-02-10 16:39:33.173 dwebb |
|
|
Kristen
Test
22859 Posts |
Posted - 2006-01-28 : 02:41:07
|
| "Is there any way I can remove these from my final output using SQL?"Not easily, that I can think of.Better [usually] to use the Presentation Layer for that sort of stuff.Kristen |
 |
|
|
|
|
|
remove control codes in database