text replace with regex in sqlserver
Posted
by Thiyaneshwaran S
on Stack Overflow
See other posts from Stack Overflow
or by Thiyaneshwaran S
Published on 2010-06-02T11:12:52Z
Indexed on
2010/06/02
11:13 UTC
Read the original article
Hit count: 249
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?
© Stack Overflow or respective owner