I have the following text in my
"Ich bin eine SuperbProdukt"
I have a full-text search enabled on the column and I can search for it by executing the following query that I wrote :
SELECT FROM MY_TABLE WHERE CONTAINS(Title, ' "Ich*" ')
The query gives me all the result that contains my search criteria, I can also search for other words within the whole text such as "
Superb" and get the same record back. However, I am trying to have a search functionality that returns results even when I give keywords that are not the beginning of any words in a phrase, but rather it's in between. For instance, I am expecting to get the same record back when searching for "
Is there a way to achieve this in SQL server without using
LIKE operation? I heard that
CharIndex can do the job, but I have no clue how that can be helpful in my scenario.
P.S: I am using SQL SERVER 2012 on Azure.