Like search not returning proper results

[capone67]

I have a like SQL search running on an ASP web site. The search works in general.

Here is the SQL

SELECT ForModels.*
FROM ForModels
where ForModel like '%HM%'

The problem is I can't get any results for "Like '%HM%'"
I am specifically looking for 50HMX96


Is there something in Access that doesnt like "HM"? Even in Access there are no results returned.

 

[PHV]

What about this ?
where ForModel like '*HM*'

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

 

[Craig0201]

You're using the wrong wildcard character. Access uses * not %