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