Need to find lower case entries in a table

[Terribletigger]

I work for a company that uses SAP. One quirk we constantly run into in
various modules is that if the information has been entered into SAP with a
lower case (or in some cases, with an upper case) leading letter, reports
will not run properly. For some reporting, the leading letter must be upper
case, for others, it must be lower case for the given field. I have been
trying to figure out how to run a simple query that would provide the
information so that we can "clean up" SAP on an on-going basis. I am not SQL
savvy; I generally try to stick with the simple select, append, update and
delete queries ....but any help would be appreciated.

 

[Jeff Boyce]

If you are using Access as a front-end to run reports from the data in SAP,
you could use a query and the UCase() or LCase() functions to force all
upper or all lower case in the query's output.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Dale Fye]

you can use the strComp( ) function to do some of the comparisons that you
want:

For example, if you want to find those records where the first character of
[FieldX] is supposed to be upper case, but isn't you could do something like:

SELECT [FieldX]
FROM yourTable
WHERE strComp(left([FieldX],1), ucase(left([FieldX],1)), vbBinaryCompare) <> 0

or if the whole field is suppose to be lowercase, it might look like

SELECT [FieldX]
FROM yourTable
WHERE strComp([FieldX], lcase([FieldX]), vbBinaryCompare) <> 0

--
HTH
Dale

email address is invalid
Please reply to newsgroup only.