Wild Card not giving me the desired results

  • Thread starter Thread starter Arlend Floyd
  • Start date Start date
A

Arlend Floyd

Here is what I have. It a text field with only names such as:
Anderson, Tim
Floyd, Jane
Smith, John
When I use: >=â€Anderson*†and <= “Floyd*â€
It skips the Floyd’s in my query … it’s like the = sign is not there and
only acting as < less then
If someone can point out my error it would be appreciated. Thanks
 
I bet that <= “Floy*†will show Floyd's but also Floya.

<= “Floyd†will also.

<= “Floyd1*†should work but not display some thing like Floydmo.

<= “Floyd*†is asking for more than Floyd. You want at least Floyda or
something.
 
Here is what I have. It a text field with only names such as:
Anderson, Tim
Floyd, Jane
Smith, John
When I use: >=”Anderson*” and <= “Floyd*”
It skips the Floyd’s in my query … it’s like the = sign is not there and
only acting as < less then
If someone can point out my error it would be appreciated. Thanks
Click to expand...

Wildcards are *ONLY* interpreted as wildcards if you use the LIKE operator
instead of = or <= or >=. Those operators will see an asterisk as just a
literal asterisk; since the ASCII value for a comma is x'2C' and that of an
asterisk is x'2A', the text string "Floyd," is in fact greater than the text
string "Floyd*".

Just leave off the asterisks, and perhaps append a Z to the Floyd (since the
string "Floyd, Jane" is in fact greater than the string "Floyd".
 
Arlend said:
Here is what I have. It a text field with only names such as:
Anderson, Tim
Floyd, Jane
Smith, John
When I use: >=”Anderson*” and <= “Floyd*”
It skips the Floyd’s in my query … it’s like the = sign is not there and
only acting as < less then
If someone can point out my error it would be appreciated. Thanks
Click to expand...


You can only use wildcard matching with the Like operator so
that idea is not going to work.

I think you can get an acceptable result using:
 
Thanks to all of you, I will post back and let you know what I used.

Thanks, Arlend
 
Back
Top