I have a database of 5,000 records of names. some names are written in caps. some records have an "XXX" or "xxx" at the end of the name field.
How would I write a query that sorts out the names written in CAPS?
Additionally, how would I write a querry that sorts out all the records ending in "xxx" or "XXX"?