Wild Card not giving me the desired results

[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

 

[Jerry Whittle]

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.

 

[John W. Vinson]

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

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".

 

[Marshall Barton]

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

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:

 

[Arlend Floyd]

Thanks to all of you, I will post back and let you know what I used.

Thanks, Arlend

 

[Arlend Floyd]

I went with Marshall's method.. the 3 zzz (It Works)

Thanks again

 

[John W. Vinson]

I went with Marshall's method.. the 3 zzz (It Works)

Just don't let it put you to sleep... zzz...