Finding UPPERCASE records in a query 1

[AllanBowker]

I have a list of company names in a database

ABC Co Ltd
Widgets R Us
FRED BLOGGS & SON
Wonderstuff World
THE MODEL SHOP
Vicks Vans
TIMEPIECES

How could I create a query that would remove all companies that have a name that is completely in uppercase but leave the records that are in propercase alone?

i.e. Delete
FRED BLOGGS & SON
THE MODEL SHOP
TIMEPIECES

Thus leaving
ABC Co Ltd
Widgets R Us
Wonderstuff World
Vicks Vans

FIRST ANSWER THAT SOLVES MY PROBLEM GETS A STAR !

 

[BlackKnight]

Hi,

You can use a public function in a module then use this delete query:

DELETE table1.Name, IsUpCase([Name]) AS UpCase
FROM table1
WHERE (((IsUpCase([Name]))=True));

Have a good one!
BK