Use of contains in sql server

Question

I need a table name. Product has 3 columns, including:

Product-id
name
Price

In the name column, all product names are present. For example: 1340 GPS, 1340T GPS etc.

When I write

select top 10 * from product where contains(name,'1340');

Result 1 row 1340 GPS

But when I search

select top 10 * from product where name like '%1340%';

Then the result is 1340 GPS and 1340T GPS.

Actually, I need it to display both rows like the LIKE operator when I use contains().

How do I do it?

Answer 1

The straightforward method is shown here. You can use the operator "*" before in the contain syntax. but you need to use double quotes before and after the search string. Check the following:

SELECT *
FROM product
WHERE CONTAINS(name,'"*1340*"');

I hope this helps you.