Cacher is the code snippet organizer for pro developers

[...]
WHERE
  REGEXP_LIKE(column, '^[0-9]+?$') -- Only positive numbers
  REGEXP_LIKE(column, '^-?[0-9]+?$') -- Positive or negative numbers
  REGEXP_LIKE(column, '^-?[0-9]+(\.[0-9]+)?$') -- Decimal numbers (neg or pos)