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

Rabu, 22 Mei 2013

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

John,

Thank you very much.

Based on your input, I altered my WHERE clause like this...
[Between '" & Me.LastName1 & "a' And '" & Me.LastName2 & "z']

Ozair.

--- In MS_Access_Professionals@yahoogroups.com, John Viescas <JohnV@...> wrote:
>
> 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
>