Uppercase formula to suppress text 1

[jchewsmith]

I have a varchar field that is populated with either all uppercase letters or camel case. I want to be able to filter out the words that are all uppercase. Is this possible.

So field equals

ABC CO
Def Co
GHIA LLC

I want to suppress all except the Def Co fields?

 

[kray4660]

There maybe a way to do this. I just checked with one of my databases, but not sure it will work with all databases. First off in Options and Report Options, you need to uncheck the 'Database Server is Case-Insensitive'.

Then have a formula something like this for your filter.
if {somnefield}= uppercase({somefield}) then false else true

 

[jchewsmith]

Worked perfectly!

Thank You