I would like help with search using full text search in SQL Server. Today I have a table that stores materials and I'm doing a search using the full text search with contains
SELECT * FROM MATERIAL WHERE CONTAINS(MAT_D040I1, '"FUSO*"' )
With this the query will bring all the materials that have started by FUSE for example
MEITECH FUSE EVA20048 TRAY ENGINE JG 24 FUSES
But I would like to do a search that does not only bring the started by and yes contains in the middle of the word (like type)
SELECT * FROM MATERIAL WHERE MAT_D040I1 like '%FUSO%'
With this in addition to bringing materials FUSO MEITECH EVA20048 and TRAY ENGINE JG 24 FUSES would bring SCREW ADJUSTMENT DII 2A RS and SCREW SXT S / ENC MA 4X30MM
I would like to do something like this with full text search instead of like ???
If you have any questions, please let me know.