pcsoft.us.windevCopyright 2026, PC SOFT10 Oct 2015 00:57:00 Z9 Oct 2015 23:37:00 ZHi All, I'm implementing this kind of index in a description item in a file of product. If I write for example Toyota hiace, it works perfect. But my client tells me if there is a way to make the same search by only writting toy hia How can I make this index work like this. The former inventory system my client used to have made the finds of records in that way. I have looked in the online help that mentions the "Syntax of the search value" but it does not seems to work the way I need. I tried the "+" "-" "~" "*" signs. Thank you for your help. James30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54411-wd18-full-text-index-search-mode/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54411-wd18-full-text-index-search-mode-54414/read.awp10 Oct 2015 00:57:00 ZThank ICI for your response, I will try that alternative. Thank you James.https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54411-wd18-full-text-index-search-mode-54414/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54411-wd18-full-text-index-search-mode-54414/read.awpWD18 - Full-Text index Search modeguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54411-wd18-full-text-index-search-mode-54413/read.awp9 Oct 2015 23:58:00 ZHi James. Try with this (without Full-Text) SELECT CarName FROM MyCars where MyCars.CarName LIKE '%Toy%' See also Syntaxhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54411-wd18-full-text-index-search-mode-54413/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54411-wd18-full-text-index-search-mode-54413/read.awpWD18 - Full-Text index Search mode