Avoid Alltrim, unless you REALLY need it, which probably is close to never! And it's much faster to use a variable in the where clause.

lcText=Thisform.search.value
WHERE Student.descr=lctext and " "$UPPER(descr) 

>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) )
>