How to get part of a string between two HTML tags in a column
I have values such as below in a column of a table in SQL Server 2022.
What I need is to grab with a SELECT statement the value between
Tabelname: JOB
Column: URL
..V 2011284 je mapelle velogstell V I saw same explanations but did not understand it.
I tried with SUBSTRING and CHARINDEX, but didn't get the value I need.
What I expect is the value between and tags in a separate column. I need this value to compare it with other tables.