>search the record from whole veriable, if "khubaib" is in verialbe. khubaib khalid, khubaib zia, even"KHUBAIB KHALID" in upper and lower case. i want khubaib
>thanks
>this code is working in set filter to but not in sql
>
>

>WHERE  ( Student.descr=ALLTRIM(Thisform.search.value)and" "$UPPER(descr) )
>

Do you want the record starting from KHUBAIB or anywhere in the string?

If the former, then

lcValue = upper(ALLTRIM(Thisform.search.value)) + ' %'

where upper(Student.Descr) LIKE &lcValue

I would rather construct the whole SQL as a string using textmerge.