Full text Search problem
Hey guys, I want to do a full text search using wildcards but I can't seem to find an equivalent of the one I used to do with LIKE operator.
For example I want to full text search a column for this value USING CONTAINS(columnName,'"*EN*"') but it doesnt give me the rows with values RENAME,RENOUNCE,ect.
But when I used this CONTAINS(columnName,'"*REN*"') OR CONTAINS(columnName,'"REN*"') it gives me the results I expect.It seems that it is doing the STARTSWITH operation.
How do I do this?Any help will be highly appreciated.
"Dont you ever give up!"
\"Dont you ever give up!\"