The search results at my prod sql server ( MS SQL 2014 ) are not consistent.
The example is below,
1. SELECT * FROM item where contains(description , '"*28242*"') and itemnum ='5003940';
No row found
2. SELECT * FROM item where description like '%28242%' and itemnum ='5003940';
The expected row found ( 1 row )
Is this normal ?
How do we fix the issue ?