I'm using the following function to find integers: where NZ_SQLEXTN..REGEXP_LIKE(d.ID, '[0-9]')
I just noticed that it's not picking up negative numbers. When I do where NZ_SQLEXTN..REGEXP_LIKE(d.ID, '[^0-9]')
, the result set is all negative numbers.
How do I include negative numbers in the regex expression?
See Question&Answers more detail:os