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