Page 1 of 1

Logical Substring search result

Posted: Sun Oct 16, 2016 9:33 pm
by John R. Sowden
I guess I have been too spoiled by Foxpro 2.6/DOS.

I have not found a logical operator (true/false) regarding a substring search. I use this all the time. If a user is looking for for a name, but does not know how to spell it, I tell them just key in the part of the name that you know how to spell. Then they are shown all of the names that have that string of characters in it. Then they can choose the correct one.

display all for 'mari' $ name$

Hope I'm missing something in the documentation.

John

Re: Logical Substring search result

Posted: Sun Oct 16, 2016 9:56 pm
by IdeasVacuum

Re: Logical Substring search result

Posted: Sun Oct 16, 2016 10:09 pm
by John R. Sowden
Thank you. I passed on that while searching because it asked for the location where the searching string would appear in the searched string, and I felt that was too much to ask of a user. Thanks to your direction (the mountain can be climbed), I notices the word optional! It also appears that findstring does more that just a logical substring search.

John