I have the following scenario.
I have a column in a database which can have one or more paragraphs <P></P>
I have the following data...
DECLARE @Text Nvarchar(250)
DECLARE @StartPoint int
DECLARE @EndPoint int
SET @Text = 'Paragraph One <P>product1=1234 prodcut2=5678</p>Paragraph Two <P>product1=1234</P>Paragraph Three<P>prodcut2=5678</P>Paragraph Four <P>prodcut2=1111</P>'
The end result is such that each paragraph should have product1 and product2.
Paragraphs which currently have product1 and product2 should not be processed.