I need a table name. Product has 3 columns, including:
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?