SQL help

[arage]

SQL help
Could someone help me polish my SQL below? I’m trying to set a combo box’s row source and am trying to tell the WHERE clause of my SQL to search a field for an occurrence of the word “Home Hardware” any place in the field, but I haven’t gotten anything to work yet. Please advise.

strSQL = "SELECT RetailerNumber & '-' & RetailerStoreNumber & ' ' & StoreName AS Retailer,RetailerNumber,RetailerStoreNumber,StoreName,Address1,Address2,City,Province,PostalCode,PhoneNumber,RegionCode FROM tblRetailerStore WHERE RegionCode ='" & 1301 & "' and StoreName = *Home Hardware*"

 

[RichMorrison]

I think you want StoreName Like '*Home Hardware*'

 

[arage]

I modified to this & tells me there’s a syntax error…

strSQL = "SELECT RetailerNumber & '-' & RetailerStoreNumber & ' ' & StoreName AS Retailer,RetailerNumber,RetailerStoreNumber,StoreName,Address1,Address2,City,Province,PostalCode,PhoneNumber,RegionCode FROM tblRetailerStore WHERE RegionCode ='" & 1301 & "' AND StoreName = '*"& Home Hardware &"*'"

 

[arage]

Voila!

strSQL = "SELECT RetailerNumber & '-' & RetailerStoreNumber & ' ' & StoreName AS Retailer,RetailerNumber,RetailerStoreNumber,StoreName,Address1,Address2,City,Province,PostalCode,PhoneNumber,RegionCode FROM tblRetailerStore WHERE RegionCode ='" & 1301 & "' AND StoreName LIKE '*Home Hardware*'"