>You can use LIKE SQL operator.
select number,last_name,first_name,location,status ;
> from refdocswithaddress into cursor refdoclist nofilter ;
> where UPPER(refdocswithaddress.last_name) LIKE (ALLTRIM(mreflast_name) + "%")
>
Thanks Sergey. I tried this code, and still did not achieve the result. Should I insert another "%" before the name also?
Basically, the result is displayed in a grid. With the change in code, the behavior is still the same.
- Ravi
True greatness consists in being great in little things.
- Charles Simmons