Re: [GENERAL] integer only sposix/regex

2009-06-15 Thread Steve Atkins
On Jun 15, 2009, at 8:21 PM, rodeored wrote: I'm trying to search phone numbers for digits. Unfortunately, the validation has been sloppy and the numbers are not just numbers, they also have dashes and probably other stuff. I would like the search to ignore anything but integers WHERE (a.phone

[GENERAL] integer only sposix/regex

2009-06-15 Thread rodeored
I'm trying to search phone numbers for digits. Unfortunately, the validation has been sloppy and the numbers are not just numbers, they also have dashes and probably other stuff. I would like the search to ignore anything but integers WHERE (a.phone1 ~* '.*626.*' OR a.phone2 ~* '.*626.*' OR a.phon