SQL Like operator
Posted on 2004-10-09
I am searching to find like items, for instance Bath tub, Bath tub jetted, Bath tub white.
I use this sql to find like items:
sql = "SELECT DISTINCT ContractItems.txtItemDescription " & _
"FROM ContractItems " & _
"WHERE ContractItems.txtItemType LIKE '" & msItemType & "%" & "'"
This works as long as the first word is bath. If I type tub then 0 records found. I want to be able to fine tub no matter where its located in the string even if it's"bathtub". What is the correct syntax to do that. I've tried ' "%" " & msItemType & "%" & "'" but that gives syntax error and I don't know if it will work with "baththb".
Thanks in advance