Can you show with some examples what the problem is?

>>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.