|
| WD18 - Full-Text index Search mode |
| Iniciado por guest, 09,oct. 2015 23:37 - 2 respuestas |
| |
| | | |
|
| |
| Publicado el 09,octubre 2015 - 23:37 |
Hi 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.
James |
| |
| |
| | | |
|
| | |
| |
| Publicado el 09,octubre 2015 - 23:58 |
Hi James.
Try with this (without Full-Text)
SELECT CarName FROM MyCars where MyCars.CarName LIKE '%Toy%'
See also
Syntax |
| |
| |
| | | |
|
| | |
| |
| Publicado el 10,octubre 2015 - 00:57 |
Thank ICI for your response,
I will try that alternative.
Thank you
James. |
| |
| |
| | | |
|
| | | | |
| | |
|