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 ?
Answer by anthony.green ·
You can't do a suffix search on a full text catalog only prefix searches, so the leading * is throwing it off
It would have to be something like the below
SELECT * FROM item where contains(description , '"28242*"') and itemnum ='5003940';
Can you please suggest few of the techniques/procedures that we should do on database to run the system without any harm and to save from danger situations and to identify it before as like prior intimation?