I have run out of ways to write this sql statement and I still can't get it
to work. I am entering text in a text box and trying to find records that
match the search text. My sql statement looks like this:
"select * from streets where streetname like '" & sText & "*" & " '"
If "M" is the search text, I want to see all records that start w/ "M". However,
it is showing a recordcount of 0. I assume this is just a syntax issue, can
anyone please help?

thanks, Ted