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.

Thanks!


Aldwin Enriquez
"Dont you ever give up!"

__________________
\"Dont you ever give up!\"