text replace with regex in sqlserver
- by Thiyaneshwaran S
Currently i have sql-server nvarchar(max) column which has text that starts with
"""
The only thing that varies in the pattern is the < in the class name.
The common part is
""
Some sample values are
""
""
""
All the
These span text are present only at the beginning of the column. Any such matching span in the middle should not be removed or matched.
Whats the sql server query with regex to remove all these occurance of span?