I'm having difficulty with an ASP VBScript generated XML feed, as the data in the MS SQL database contains XML Special Characters as well as HTML attributes.
I've tried stripping these out using VBScript, but because of the amount of data, it is causing the buffer limit to be exceeded.
So what I'm hoping to do, as I'm sure that it will cost less overhead, is put together an MS SQL function that will do it.
What I'm hoping to do, is -
remove all <p> <b> <h1> html tags, including style attributes.
replace special characters, including characters like £,€ etc
And out put clean data.
Assuming that my select statement reads -
FROM [dbo].[SupplierSurveySupplier] S
inner join [dbo].[Brand] B on S.BrandID = B.ID
WHERE [SupplierSurveyID] = 1
order by B.Name
And it is B.Name & B.description that I want to apply the replace / remove function too, how would I do this?
Also, given the number of records, would there be any benefit in using a view, outputting the cleaned data to a view and then using a select statement to select the data from the view?