Stripping the special characters in a texr

• Jaya Chitra

  SSCommitted

  Points: 1916

  More actions

  May 21, 2008 at 12:51 am

  #207567

  Hi all,

  I have a text which will be passed to a procedure / function and the procedure / function has to strip the special characters in the string and only text contents has to be returned.

  Can any one help me how to do it?

  Best Regards,

  M. J. J chitra

  [font="Arial"]Nothing is impossible with Hard Work[/font]:)

• jaypee_s

  Right there with Babe

  Points: 793

  More actions

  May 21, 2008 at 2:50 am

  #818421

  Hi

  Check this link

  http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=56713

  Thanks

  Jaypee.s

• Matija Lah

  SSCertifiable

  Points: 6429

  More actions

  May 21, 2008 at 2:57 am

  #818427

  Which special characters?

  ML

  ---
  Matija Lah, SQL Server MVP
  http://milambda.blogspot.com

• Jaya Chitra

  SSCommitted

  Points: 1916

  More actions

  May 21, 2008 at 3:08 am

  #818431

  Thank you Jay.

  It is working this is what I need it.

  [font="Arial"]Nothing is impossible with Hard Work[/font]:)