"Jeff Gardner" wrote...
> Greetings:
>
> I am trying to locate incorrect data in a column using REGEXP. Only
> numeric data is allowed but I am importing data, some of which is not
> properly formatted. I am using:
>
> SELECT *
> FROM `table`
> WHERE `column` REGEXP "[^[:digit:]]";
>
> to locate any value that is not a number. I've tried several variations
> and I get an empty set back. I know that there are illegal characters in
> some of the data but I can't seem to locate it using this query. The
> field can contain anywhere from 1 to 6 digits, if that is relevant. Advice
> is much appreciated.

Could you post an example of the "invalid" data,
on my 5.1.12 you query works.


Regards
Dimitre