>I have create a table Namely "student.dbf" with fields namely 1.ID 2. name 3. Class 4. Place. I want to search the student whose name letter begin with *A* or *B* or *C* or *D* etc and result will be display in browse window
>
>I had create a form and placed one Text box and one command button namely txtsearch and cmdsearch. for example I had entered letter "A" in txtsearch and click cmdsarch, I want to search the student whose name letter begin with *A* and result will be display in browse window
>
>
>
>How to write code?
In the commandbutton's click event:
lcText=alltrim(upper(this.parent.txtSearch.value))
Select * from student where upper(student) like lcText+'%'