Loading ...
Sorry, an error occurred while loading the content.
 

How to retrieve only data in sql server 2000

Expand Messages
  • s a
    Hi, I have a column in sql server 2000 which has html tags like , , , etc. eg:
    Message 1 of 1 , Mar 4, 2007
      Hi,

      I have a column in sql server 2000 which has html tags like <span>,<font>,<b>,<p> etc.
      eg:
      <SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-fareast-font-family: 'Times New Roman'; mso-ansi-language: EN-US; mso-fareast-language: EN-US; mso-bidi-language: AR-SA">Stop condition to avoid applications from going ahead if DSR with loan & OD is 65% and including CC is 75% at </SPAN><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-fareast-font-family: 'Times New Roman'; mso-ansi-language: EN-US; mso-fareast-language: EN-US; mso-bidi-language: AR-SA">Outcome Screen of DC & DV  </SPAN>

      How can i get rid of these tags and get the data alone in sql query.(In sql server 2000)

      Please help.

      Thanks a lot.




      ---------------------------------
      Now that's room service! Choose from over 150,000 hotels
      in 45,000 destinations on Yahoo! Travel to find your fit.

      [Non-text portions of this message have been removed]
    Your message has been successfully submitted and would be delivered to recipients shortly.