Filtering using a Substring Help

[r_walk76]

Hello All

I have been to the moon and back trying to figurer this one out; I have a form, with an Option group that a user can use to filter their data. Upon using a case statement the code looks like this

Case 1
strFilterSQL = strSQL & " Where [Device Name] = 'PE';"
Case 2


strFilterSQL = strSQL & " Where [Device Name] = 'CS';"

This works however the returned values is a record that has the [Device Name] value of ONLY PE value. I want it to return all records that begin with the letters PE. Similiar to a "LIKE" statement in SQL, but i keep getting errors in VB when i type things like : LIKE [Device Name] = 'PE%' ??????????

HTH

Thanks

[StepUP]

Instead of LIKE [Device Name] = 'PE%'

Try

Where [Device Name] Like 'PE*'

[r_walk76]

Thanks a Million, I got it to work, actually for some reason my Access liked the % wildcard instead of the *, anyways the syntax was the same as what you suggested, I wasnt getting any output with the * as the wildcard, but thought I would try it with % and it worked.

Case 1
strFilterSQL = strSQL & " Where [Device Name] Like 'PE%';"
Case 2
strFilterSQL = strSQL & " Where [Device Name] Like 'CS%';"

Oh wel IT WORKS! Thanks