>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
>
>How to write code?

lcNamePrefix = "A"
SELECT * FROM student WHERE name LIKE lcNamePrefix + "%"