hi,
i try via vfp8 as under ,it works
i hope this help you

SCAN FOR atc(trim(thisform.text1.value),nam) > 0
? nam
endscan

OR

SCAN FOR atc(trim('Ali'),nam) > 0
? nam
endscan

m.qasem

>Dear Experts
>
>Field1 entitled Name of Table1 has a character type data as
>
>Ahmed Ali
>Ali Reza
>Malik Hassan
>
>I want to extract data that has complete word "Ali" for example if use following commands
>

>SNAME=ALLTRIM("Ali")
>
>SELECT name FROM MASTER;
>WHERE name LIKE SNAME;
>INTO cursor TEST
>

>Then it displays
>Ahmed Ali
>Ali Reza
>Malik Hassan
>
>But I want to extract only following records
>Ahmed Ali
>Ali Reza
>
>Please help