String comparison and manipulation

[Daniel Lamb]

I'm using Access '97

What are the relevant functions in Access that correspond to Upper, Lower
and Proper in Excel? I am trying to compare and integrate data from two
sources but all of the name and contact information in one source is in
upper case while the other source is in so called proper case.

Is there a Find command in Access similar to that in Excel? I have strings
I need to use MID to extract the data but without a calculated way to start
or stop the extraction it is proving difficult.

 

[Douglas J. Steele]

UCase, LCase and StrConv( , vbProperCase) respectively.

InStr is the equivalent of Find.

 

[Ronald W. Roberts]

Lookup "String Manipulation Keyword Summary" in help.

Your going to have better luck in this or any newsgroup if you give
examples
of what you are trying to do.

Ron