wildcard search

[Xzibit7]

I am doing a simple select query in access. I am trying to retrieve all the values of an item name that have the word bushing in them. The table has the format like electrical,bushing. I have tried "*" & "Bushing" and I get no results although I know that these items are in the table any help would be appreciated. Thanks

 

[rac2]

Maybe

SELECT * FROM MyTable
WHERE item_name LIKE "*bushing*"

thinking that "*bushing" matches items ending in "bushing".

 

[Xzibit7]

Thank you kindly