uppercase data

Question

any ideas how i can view all records that contain all uppercase letters.  field has company names but there are some that are in uppercase and i can't change the casing of the existing records that are properly cased, i only want to change the records that have uppercasing.

 

thanks in advance

 

Answer 1

Didn't you ask similar question a few days ago?

To view records having all letters in uppercase you may use:

BROWSE FOR LEN(CHRTRAN(field, "ABCDEFGHIJKLMNOPQRSTUVWXYZ ", "")) > 0

 

Answer 2

I'd do it a little differently than Pavel, but I suspect both approaches are equally good:

BROWSE FOR UPPER(company)=company

and, to automate a first try at fixing it, something like:

REPLACE company with PROPER(company) FOR UPPER(company) = company

PROPER() won't do a perfect job, but it'll do a decent one.

Tamar

Answer 3

Pavel,

That command is not working for me so that's why i reposted again (but great memory on your part).

 

Tamar,

That worked to perfection! thanks for the help guys!