working with the SELECT...FROM stuff

Hi, I`m trying to open an MSHFlexGrid showing only the rows in an Adodc that I want it to. The code I`m using:
Adodc1.RecordSource = "SELECT * FROM Estudiantes WHERE Profesor LIKE '%" & Str(numero) & "'%;"
Adodc1.Refresh
flexdata.Refresh
It keeps telling me that there´s an error with the SELECT...FROM line and then of course another ont with the Adodc line.
Could you help?:confused

Looks like you have a single quote out of place:

VB Code:

'Change
Adodc1.RecordSource = "SELECT * FROM Estudiantes WHERE Profesor LIKE '%" & Str(numero) & "'%;" 
 
'To
Adodc1.RecordSource = "SELECT * FROM Estudiantes WHERE Profesor LIKE '%" & Str(numero) & "%';"