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 |
|
brace77
Starting Member
25 Posts |
 Posted - 2009-10-20 : 06:47:35
|
| In the subject the code of my dreams.This topic has been coered in many other posts, like (http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=90034) where a almost working function was there (there are too many cases in which that function fails).Is there something new? I mean is it possible to have the "final" function tht uses the full RTF specification or does Microsoft introuced any new thing in SQL Server 2008 to perform what I think everyone need? I mean:TABLE1 has a varchar(max) field containing RTF (I call this field RTFFIELD)Why SQL SERVER doesn't have a *obvious* feature likeSELECT RTFTOTEXT(RTFFIELD) FROM TABLE1??? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
SELECT CAST (TABLE.RTFFIELD AS VARCHAR(MAX))