Using the wildcard '*' character at the start of the search time like *Music to match all the words in ending in the suffix "Music" i came to know that IFTS doesnt support this property
So my question is suppose i'm doing search on Music .Its give me all the result which starts with the word "music". my problem is i want to have "XPRESSMUSIC" also in my result or where ever in the text word Music is found. if i uses Like operator '%Music%' its gives me all the results which contains Music anywhere also the Word XpressMusic,
Can any one help me.what should i do to get the XpressMusic when i search For Music.