Is this kind of query possible? :-) 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 |