>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) )
>
WHERE (UPPER(Student.descr) LIKE [%]+UPPER(ALLTRIM(Thisform.search.value))+[%] )
If you want Descr just to BEGIN with UPPER(ALLTRIM(Thisform.search.value)) remove first [%] sign.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.