Re: [GENERAL] selecting for type cast failures

2013-03-10 Thread Adrian Klaver
On 03/07/2013 08:56 PM, David Johnston wrote: Adrian Klaver-3 wrote My opinion, it would take more time to concoct regexes that cover all the corner cases than to write a script that walks the through the data , finds the problem data and flags them. ISTM that using regular expressions is nece

Re: [GENERAL] selecting for type cast failures

2013-03-09 Thread David Johnston
Adrian Klaver-3 wrote > My opinion, it would take more time to concoct regexes that cover all > the corner cases than to write a script that walks the through the data > , finds the problem data and flags them. ISTM that using regular expressions is necessary regardless of whether you put them i

Re: [GENERAL] selecting for type cast failures

2013-03-07 Thread Adrian Klaver
On 03/07/2013 05:08 PM, Natalie Wenz wrote: Hi! I am working on updating some of our tables to use appropriate native data types; they were all defined as text when they were created years ago. What I am running into, though, is there are some records that have bad data in them, where they c

Re: [GENERAL] selecting for type cast failures

2013-03-07 Thread Guy Rouillier
On 3/7/2013 8:08 PM, Natalie Wenz wrote: I am working on updating some of our tables to use appropriate native data types; they were all defined as text when they were created years ago. What I am running into, though, is there are some records that have bad data in them, where they can't be su

[GENERAL] selecting for type cast failures

2013-03-07 Thread Natalie Wenz
Hi! I am working on updating some of our tables to use appropriate native data types; they were all defined as text when they were created years ago. What I am running into, though, is there are some records that have bad data in them, where they can't be successfully converted to int, or floa