Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Access 2000 Query
- Thread starter tallbarb
- Start date
I would try the StrComp() function. For example:
[tt]
SELECT *
FROM Table1
WHERE StrComp([Field1],'SMITH',0)=0;
[/tt]
...will return records from Table1 where the value in Field1 equals "SMITH", but not "smith" or "Smith" or any other upper-lower case arrangement of the word.
[tt]
SELECT *
FROM Table1
WHERE StrComp([Field1],'SMITH',0)=0;
[/tt]
...will return records from Table1 where the value in Field1 equals "SMITH", but not "smith" or "Smith" or any other upper-lower case arrangement of the word.
- Status
Similar threads
- Locked
- Question
- Locked
- Question