like% TEXT% in full text search

1

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.

    
asked by anonymous 11.04.2016 / 20:46

0 answers