ACCESS FEED: RE: [MS_AccessPros] using Between in Query for String values

Selasa, 21 Mei 2013

RE: [MS_AccessPros] using Between in Query for String values

Ozair-

When you use BETWEEN, the query engine evaluates it like:

WHERE LastName >= 'ca*' AND LastName <= 'co*'

In other words, it doesn't evaluate the literal using LIKE, so the * is
simply another character.

Try using BETWEEN 'ca' AND 'cozzzzzz'

When I search for your account online, it shows only one account registered
to Yahoo ID "ozairkhalidozair" - set to receive the Daily Digest. I can
change that for you, or you can change it yourself. Go to the group website
and click Edit Membership near the top left of the page. Note that Yahoo
will occasionally ask you to login again.

John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)

-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Ozair
Sent: Tuesday, May 21, 2013 2:29 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] using Between in Query for String values

Hello,

SELECT dbo_T_People.LastName FROM dbo_T_People WHERE
(((dbo_T_People.LastName) Between 'ca*' And 'co*')) ORDER BY
dbo_T_People.LastName DESC;

The above query did not return many names which exist in the table.
For example...
LastName
Cowgill
Cowett
Cowen
cowell
Cowdrey
Cowart
Cowan
Covolo
Covington

HOWEVER if I alter the query [Between 'ca*' And 'cp*'] the missing records
do show up.

Please help and explain.

Regards,
Ozair

P.S. When I tried to post this question, I had been asked to "Join Group" (
I think I am already a member - still getting Daily Digest emails ).

------------------------------------

Yahoo! Groups Links