hi,
i agree,thank you



>I don't see much of a difference between these two solutions. If one gives the result, the other also should give the same result.
>
>>hi,
>>thank you for reply
>>i try it but no result no error, i have another soluation as..
>>it works
>>

>>        if LEN(ALLTRIM(thisform.text3.value)) >= 3
>> SELECT depno,depname,mobile,tel,empname,empno from emp1;
>>        where  atc(trim(thisform.text3.value) ,empname)>0 ;
>>         ORDER by empno;
>>          into cursor crsMyCursor
>>

>>>Not sure if I got your description right - do you want something like this?:
>>>

>>>* Procedure text3.InterActiveChange()
>>>Local lcEmpName
>>>lcEmpName = LOWER(Trim(NVL(thisform.text3.value,'')))
>>>If Len(m.lcEmpName) >= 3
>>>    SELECT * FROM emp1 WHERE LOWER(empname) Like '%&lcEmpName%' Into ...
>>>Endif
>>>

>>>
>>>
>>>hth
>>>-Stefan
>>>
>>>
>>>>hi all,
>>>>i need help to start locate if thisform.text3.value>=3 characters
>>>>
>>>>via this code(atc(trim.........)
>>>>
>>>>

>>>>SELECT depno,depname,mobile,tel,empname,empno from emp1;
>>>>         where  atc(trim(thisform.text3.value) ,empname)>0 ;
>>>>         ORDER by empno;
>>>>          into cursor crsMyCursor
>>>>

>>>>
>>>>thanks