Where Expression to quickly and accurately find a name (character) in a table

[req41273]

What is the correct Where expression to quickly and accurately find a name in the data while in the attached window?  Example, I need to find a provider name of Stallings...what expression would I type?  Please see attachment

thanks

[req41273]

What is the correct Where expression to quickly and accurately find a name in the data while in the attached window?  Example, I need to find a provider name of Stallings...what expression would I type?  Please see attachment

thanks

[ballardw]

Some things to you need to provide:

Is CASE important? Matching both Stallings and STALLINGS or not?

Is composite content important? Is  "JohnStallings" yes one word on purpose, supposed to be a match for "Stallings"?

Do you need to search more than one variable?

Please do not post identical posts on this forum. It generally will not get a quicker or better answer.

[req41273]

No, case is not important.  Only one variable and if it contains the letters stallings and nothing else or stallings and few letters  after it.

[req41273]

I did not intentionally post multiple times.  The system website did this.

[req41273]

What is the correct Where expression to quickly and accurately find a name in the data while in the attached window?  Example, I need to find a provider name of Stallings...what expression would I type?  Please see attachment

thanks

[Reeza]

FYI - I've merged your posts, not sure why you have three identical ones.

Also, please just insert your image rather than have attachments. I can't download attachments anymore and many others can't either.