Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Search form slightly misbehaving
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00679248
Message ID:
00680053
Views:
28
then, you got to some work here..

Try this...

lcFilterExpr = ""
FOR lnI = 1 TO LEN(lcSearchString)
lcFilterExpr = lcFilterExpr + "SUBSTR(Agency_Name," + STR(lnI) + ",1) >= '" + SUBSTR(lcSearchString,lnI,1) + "' AND "
NEXT
lcFilterExpr = LEFT(lcFilterExpr,LEN(lcFilterExpr) - 4)
SET FILTER TO &lcFilterExpr


>Jayesh,
>
>You're close, but the search result would be the names starting with L's and M's and N's and so on through letter Z.
>
>And if the search text contains "LE" the result starts with
>LEALMAN
>and skips LARGO and the rest after LEALMAN through the names beginning with the letter Z.
>
>Hope this defines the problem better.
- Jayesh
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform