1
I would like some help regarding the search using full text search in SQL Server. Today I have a table that stores materials and I’m doing a search using full text search with contains getting like this
SELECT * FROM MATERIAL WHERE CONTAINS(MAT_D040I1, '"FUSO*"' )
With this query will bring all the materials you have started by FUSO for example
FUSO MEITECH EVA20048 TRAY SPLICE JG 24 MERGERS
but I would like to do a research that does not only bring the initiated by and rather contains in the middle of the word (like)
SELECT * FROM MATERIAL WHERE MAT_D040I1 like '%FUSO%'
with this in addition to bringing the materials FUSO MEITECH EVA20048 and TRAY SPLICING JG 24 FUSOES would bring SCREW SETTING DII 2A RS and SCREW SXT S/ENC MA 4X30MM
it would be like doing something like this with full text search instead of like???
If you have any doubts, please inform me.
It’s not just putting the
*
also on the other side of the word ?– Diego Souza
Not rsrs tested but does not work, so I read the advantage of full text search is the use of index, if allow a joker at the beginning would not have to use the indexing, but I was wondering if there is another way to solve this
– Daniel Saraiva