SQL thown off by {} symbols
Posted: Wed Jul 03, 2019 3:30 am
So I am trying to do a one off quick report and I ran into something that stopped me cold.
If I do something like this:
I think it is replacing the {2} in there, or at least being confused.
If I hit "retrieve colums" a "SQL Expressions" dialog appears with two lines that have 2 for the label and 2 entered in the two textboxes next to them.
Is there any way to get it to ignore or escape the curly braces in my regular expressions?
If I do something like this:
Code: Select all
where process_date between '2019-01-01' and '2019-12-31' and t.code REGEXP '^[a-z|A-Z]{2}[0-9]{2}.[5-6]$'If I hit "retrieve colums" a "SQL Expressions" dialog appears with two lines that have 2 for the label and 2 entered in the two textboxes next to them.
Is there any way to get it to ignore or escape the curly braces in my regular expressions?