Hi, I need a SQL server solution to extract text between html tags. For example the below:

Getting following error: message.ResponseEntry[0].Transaction.reasons.reason.code - When trying to active this account which denied initially due to missing info account.

The customer wants to get a discount code.

Same issue we has on customer123 - and customer has called back for updates !

Should shows be extracted as:

Getting following error: message.ResponseEntry[0].Transaction.reasons.reason.code - When trying to active this account which denied initially due to missing info;The customer wants to get a discount code.Same issue we has on customer123 - and customer has called back for updates !

I don't want to a user defined function.

Thank you!