I have successfully created an
FTS index on a column where we have stored the name of medicines e.g:
Amoxicillin 250mg capsules 21 capsule Verapamil 160mg tablets 100 tablet
When I search with the parameters
tablets it works fine.
But when I search for
blets it doesn't come up with the answer. However the same keywords work with
select * from AMPP as a WHERE Contains(A.[NM] ,'%Amoxici%')
Above query has no results . however below query returns 140 rows in result.
select * from AMPP as a WHERE Contains(A.[NM] ,'%Amoxicillin%') select * from AMPP as a WHERE a.nm like '%Amoxici%'