SQL query with a wildcard 1

[scotttom]

I need a bit of help with a SQL query that I'm running through VBA. I have a table that has strings of various length (asd, asdf, qwerty) in column tbl.ProjectPrefix.

What I'm looking to get is the value of tbl.Text if the value in a text box starts with any of the values in tbl.ProjectPrefix.

SO if I type "asdfg" I want to see the tbl.Text values for both the "asd" and the "asdf".

SELECT tbl.Text From tbl WHERE  ((("asdfg") Like (tbl.ProjectPrefix*)))

I keep getting syntax errors or extra ( errors and I'm stumped.

Can anyone see my error?

Thanks in advance for any assistance.

Scott

 

[PHV]

Like (tbl.ProjectPrefix & '*')

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886