Using Regular Expressions extensions in Microsoft SQL Server, noticed that curly brackets are stripped from the query input. Can't quite understand the purpose of this and it makes the use of any code query in SQL server very difficult, if not impossible. I haven't found a way of escaping this out or an alternate yet. The query I'm trying to run is:
select * from CMPINSTEVT
where [Master].dbo.RegExIsMatch('.*(E|R)401\s[0-9]{2}\s[0-9]{3}',IEVT$DATA,1) <> 0
but what is actually used in the query window is
select * from CMPINSTEVT
where [Master].dbo.RegExIsMatch('.*(E|R)401\s[0-9]2\s[0-9]3',IEVT$DATA,1) <> 0
Any clues?