sql server - Perform regex (replace) in an SQL query - Stack Overflow

What is the best way to replace all '<' with < in a given database column? Basically perform s/<[^;]/</gi Notes: must work in MS SQL Server 2000 Must be repeatable (and... ... If MSSQL's regex flavor supports negative lookahead, that would be Th

stackoverflow.com