>I want to allow user to search by Wildcard, but he will not need to type the Wildcard and vfp will add it.
>For example:

ctext=thisform.txt1.value&&the user type 'xxx'
>select * from table where column1='%xxx%'&&vfp will run it with Wildcards.

select * from table where column1 like '%'+alltrim(thisform.text1.Value)+'%'

However in VFP this is case sensitive. Alternative:

select * from table where atc(alltrim(thisform.text1.Value)),column1) > 0

Cetin