Access Query - How to query text fields looking for specific lower and upper case text strings.
How can I create a query that generates text strings with exact lower/upper case?
I would like a query which generates all products that start with lower case "a"
I would like a query which generates all products that start with upper case "A"
I would like a query which generates all products that start with lower case "a"
I would like a query which generates all products that start with upper case "A"
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Use the string comparison function strComp().
Check out Access help for the syntax and the retrun values. you will want to use vbBinaryCompare as the 3rd parameter.
Check out Access help for the syntax and the retrun values. you will want to use vbBinaryCompare as the 3rd parameter.
ASKER
Where do I type these things in the query design view?
err.jpg
err.jpg
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
select * from products where Asc(Left(code,1)) = Asc("A")