Menu

#14 Remove odd handling of curly brackets

open
nobody
None
5
2015-09-27
2015-09-27
No

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?

Discussion


Log in to post a comment.

Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.