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

Selasa, 21 Mei 2013

[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 ).