I need to replace some special characters using SQL 2008, for that to generate a function.
This is the -sql- part where the replacement is made:
set @raw = replace(replace(@raw,'<br /> * ','<br/>*'),'&nbsp;',' ')
This is the result:
Cancellation policy based on the time zone of the Destination: < br / > < br / > * Canceling from 10/18/2016 at 00:00:00 to 10/18/2016 at 00:59:59: 0 USD < br / & gt * From these moments until the start date of travel 10/20/2016 00:00: 1 night (s)
How can I do to replace the part of the text that comes with those special characters:
<br /> <br />
Thank you very much.