sql :like

hi, all

Can anyone tell me what is wrong with this:

strQry = "select * from ticket where " + _
"[record date] <= #" & date1 & "#" + _
"and [Flight NO] like ' ' " & text1 & " '* ' "

Thank you in advance.

try this:

strQry = "select * from ticket where " + _
"[record date] <= #" & date1 & "#" + _
"and [Flight NO] like '" & text1 & "%'"

Thank you ,digisenze.

It worked!