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 |
|
akas
Starting Member
42 Posts |
 Posted - 2010-05-05 : 13:22:22
|
| i have one field datatype is nvarchar(max).example - in values are like:<html xmlns:msxsl="urn:schemas-microsoft-com:xslt"><head><META http-equiv="Content-Type" content="text/html; charset=UTF-16"><base target="_blank"><style> BODY, TD { background-color:#ffffff;font-family:verdana;font-size:10pt; }</style></head><body><table cellspacing="2" cellpadding="4" width="100%" height="100%"><tr><td style="font-family:verdana;font-size:16pt;">SR: NI Distribution Policy</td></tr><tr><td style="color:#666666;font-size:9pt;">KA-06916</td></tr><tr><td style="font-size:10pt;font-weight:bold;color:#000066;border-bottom:1px solid #999999;">Summary</td></tr><tr><td><FONT face=Arial size=2><SPAN style='FONT-SIZE: 11pt'><P class=MsoNormal style='MARGIN: 0in 0in 0pt'><SPAN style='FONT-SIZE: 12pt; FONT-FAMILY: Arial'>Most NI publications can be viewed and downloaded at no charge from our Web site. The address for the 'NI One Catalog' is <B><SPAN style='COLOR: blue'><A title=http://eml.ni.net/ href='http://eml.ni.net/'><SPAN style='FONT-WEIGHT: normal'><FONT color=#0033ff>http://eml.ni.net/</FONT></SPAN></A></SPAN></B>. Please note that all of the NI information is in the public domain and can therefore be downloaded, photocopied, and distributed without further permission. NI offers a wide range of publications for purchase at varying prices. There is a shipping and handling fee for all publication orders.</SPAN></P><P class=MsoNormal style='MARGIN: 0in 0in 0pt'><SPAN style='FONT-SIZE: 12pt; FONT-FAMILY: Arial'> </SPAN></P><P class=MsoNormal style='MARGIN: 0in 0in 0pt'><SPAN style='FONT-SIZE: 12pt; FONT-FAMILY: Arial'>If you prefer you may respond to this e-mail with your complete mailing address and we will be glad to send you a publications catalog free of charge.</SPAN></P><P class=MsoNormal style='MARGIN: 0in 0in 0pt'><FONT face=Tahoma size=2> </FONT></P><P class=MsoNormal style='MARGIN: 0in 0in 0pt'><FONT face=Tahoma size=2> </FONT></P><P class=MsoNormal style='MARGIN: 0in 0in 0pt'><FONT face=Tahoma size=2> </FONT></SPAN></FONT></P></td></tr><tr><td style="font-size:10pt;font-weight:bold;color:#000066;border-bottom:1px solid #999999;">Additional Comments</td></tr><tr><td><P class=MsoNormal style='MARGIN: 0in 0in 0pt'><SPAN style='COLOR: black; FONT-FAMILY: Arial'><FONT size=3>April – 04, 10/19/05 per Les Ran, updated 07/02/08 per Just Gold . </FONT></SPAN></P></td></tr><tr height="100%"><td><br></td></tr></table></body></html>--How can i get Bold Red letter text from this field? Thanks. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-05-05 : 14:43:57
|
| will the format be consistent?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
|
|
|
nvarchar(max)