Hi, I have this huge database of millions of records ... mixed in are
dozens and dozens, maybe hundreds of entries that are in all or mostly
uppercase. I do not want to lowercase them, or delete them.... just
ID them so they can be normalized. Is there any method to search
across a table for instances where more than 1 consecutive letter is
simply uppercase?

like

THE dog jumped over
THe dog jumped over
The DOg jumped over

..... all would be noticed .... can this be done or is this beyond the
capability of a query search?

Best regards

On Sat, 27 Oct 2007 21:48:27 +0200, <182719@rock.com> wrote:

> Hi, I have this huge database of millions of records ... mixed in are
> dozens and dozens, maybe hundreds of entries that are in all or mostly
> uppercase. I do not want to lowercase them, or delete them.... just
> ID them so they can be normalized. Is there any method to search
> across a table for instances where more than 1 consecutive letter is
> simply uppercase?
>
> like
>
> THE dog jumped over
> THe dog jumped over
> The DOg jumped over
>
> .... all would be noticed .... can this be done or is this beyond the
> capability of a query search?

SELECT fieldname
FROM test
WHERE fieldname REGEXP BINARY '[[:upper:]]{2,}';
--
Rik Wasmus