Finding lower case records

[SteveE]

I supply data to our customer for their system, a single table listing 1.9 millon records. 1 of the 7 fields is unique but the rest in the table can contain duplicated data.
My problem is caplial letters vs lower case.
How can I query my table to find just the mixed and lower case versions of for example "BIRMINGHAM" ie "birmingham" or "Birmingham". My customers system is rejecting the Data due to some lower case entries.

Any help appricated

Steve

 

[Rabbie]

The simplest way to solve this is to run an Update Query on the Table changing the field to Ucase(OriginalField)

This will convert all the names to Uppercase. There is a function that just capitalises the first letter but I cant remember its name. Try a search of Access Help

 

[PeterF]

Rabbie is right, if it has to be upper case.

To check or filter on non uppercase you need the strcomp function like:

StrComp([YourFieldName];UCase([YourFieldName]);0)

Make this the source of a new colum in a query and every result that's not 0 is not completely in upper case.

 

[SteveE]

Rabbie,
Many thanks, I was on someone elses PC and did not search the site properley I have found this answer in the seach function which really does work !! thanks for taking the time and trouble to reply though
Steve

 

[SteveE]

Ditto Peter