Dear Experts
>
>No example solve my problem.
>
>Please review if possibleTariq,
try this and please post what is wrong.
Christof gave you good example.
CREATE TABLE Master (Name C(40))
INSERT INTO Master VALUES ('Ahmed Ali')
INSERT INTO Master VALUES ('Ali Reza')
INSERT INTO Master VALUES ('Malik Hassan')
INSERT INTO Master VALUES ('Mahammed Ali Reza')
INSERT INTO Master VALUES ('Maali Reza')
sname = "% "+ALLTRIM("Ali")+" %"
SELECT name FROM MASTER;
WHERE ' '+name +' ' LIKE SNAME;
INTO cursor TEST
BROWSE NORMAL
_______________________________________________________________
Testing displays the presence, not the absence of bugs.
If a software application has to be designed, it has to be designed correctly!
_______________________________________________________________
Vladimir Zografski
Systems Analyst