how to create function Replace text in html

• midan1

  SSCertifiable

  Points: 5100

  More actions

  February 23, 2005 at 4:43 pm

  #66507

  need help to create function Replace on TEXT field

  and in the text field i have a HTML code

  i wont to  Replace the PATH in the HTML code

  from server-relative

  to

  absolute URL

  if in the HTML code i have an image

  like this " /images/emotions/whistling.gif "

  i wont Replace to

  " http://www.sqlservercentral.com/forums/images/emotions/whistling.gif "

  Replace this = " /images/emotions/ "

  to this = " http://www.sqlservercentral.com/forums/images/emotions/"

  how to do this

  and after use it in view in sql server

  thnks

  ilan

• February 28, 2005 at 8:00 am

  This was removed by the editor as SPAM

• Seth Washeck

  Mr or Mrs. 500

  Points: 578

  More actions

  February 28, 2005 at 3:05 pm

  #544499

  this should get you started

  declare @path varchar (150)

  set @path = 'http://www.sqlservercentral.com/forums' +

  (select top 1 [image] from [image table] where [criteria is met])

  select @path

  ---

  Kindest Regards,

  Seth Washeck
  

  If nothing in this world satisfies me, perhaps it is because I was made for another world.
  C. S. Lewis

• midan1

  SSCertifiable

  Points: 5100

  More actions

  March 1, 2005 at 5:51 pm

  #544735

  need more help

  how to do it ??????????

   create function to Replace text from table

  in   field type TEXT

  thnks ilan

• DSP-120308

  Hall of Fame

  Points: 3959

  More actions

  March 1, 2005 at 8:09 pm

  #544743

  Ilan,

  Take a look at BOL for Create Function. Between that and Seth's suggestion you should be well on your way.