'Like' operator no working in vb

Hi all, please take a look at my query, what wrong with it? how come I can use the LIKE operator from vb to access97? Please help.Thanks!

sql = "SELECT * FROM RSUser WHERE RS LIKE ' " & Me.txtSearchTextFrom.Text & " ' & "*" &;"

well for one your " and ' are kinda screwy. Sql would want it something like this...dunno about m$ft

sql = "SELECT * FROM RSUser WHERE RS LIKE ' " & Me.txtSearchTextFrom.Text & " ' " & "*" & ";"

I am sorry I meant

sql = "SELECT * FROM RSUser WHERE RS LIKE ' " & Me.txtSearchTextFrom.Text & " ' & "*" & ;"

ADO or DAO? SQL Server or Access?

[edit] oops, you already said access. [edit]

Correction:

SQL would want it like this:

sql = "select * from table where field like ' " & text1.text & "%' "

m$ft should be close, though I'm not sure about the wildcard char...

ADO/ACCESS

Use '%' for your wildcard instead of '*', like Rhoarke said.

:( it didn't work

Explain what 'didn't work' means... it always works for me. Maybe post a piece of your code where it's not working...

[edit]

If you're using the SQL you posted earlier

sql = "SELECT * FROM RSUser WHERE RS LIKE ' " & Me.txtSearchTextFrom.Text & " ' & "*" & ;"

you need to change that to

sql = "SELECT * FROM RSUser WHERE RS LIKE '" & Me.txtSearchTextFrom.Text & "%'"

[edit]

sql = "SELECT * FROM RRHEADER WHERE LOCATION LIKE ' " & Me.txtSearchTextFrom.Text & "*';"

Before with the "*", it will at least return some records, right now with the "*" it is not return any record at all... if it is working right, it should return all of the record(s) that have the me.txtSearchTextFrom.text as the first part of the text right? I tested in Access, it is working just fine, but if I want to pass this from VB, it won't work, please help. Thanks!

Reboot and Keltus adviced you to use the "%" did you try this???

try this

sql = "SELECT * FROM RRHEADER WHERE LOCATION LIKE '" & Me.txtSearchTextFrom.Text & "%'"

a) you can't use * with ADO, the wildcard for LIKE is %

b) watch out for spaces, it doesn't trim them for you, you had LIKE ' " & Me.txtSearchTextFrom.Text, which would translate to LIKE ' location'. It's going to try to match ' location' and not 'location'. See what I mean? And in the earlier version, you had a space AFTER the wildcard also.

Thanks everyone, % is the answer.