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