I have a table that has a row with below value in the indexed field (mapped to a catalog):

"Portable battery charger with charging adapters for all major electronic devices"

When I run the following query, I got this record in the result set. Any idea why does this row is returned in this query? According to MSDN, when add an asterisk (*) before the ending quotation mark, so that all text starting with the simple term specified before the asterisk is matched. In my case the term does not match, it should be “electronic dev” to match….I’m not following

we are here to help where we can, that means using our minds to create sometimes different approaches to certain scenarios, if you dont use like which will work then you are not understanding the purpose of this forum. Research more on CONTAINS if you need that function but the answer you seek is not built in stone.

we are here to help where we can, that means using our minds to create sometimes different approaches to certain scenarios, if you dont use like which will work then you are not understanding the purpose of this forum. Research more on CONTAINS if you need that function but the answer you seek is not built in stone.

We are the creators of our own reality!

The overall reason for this forum is to help others and it seems like you are trying to do that, but without addressing the main issue.

Your help is based on “forget about your problem, do it this way.” I asked a straight forward question, but it looks like you hijacked it with your “other approaches”.