|
Subject:
|
Full text Search problem
|
|
Posted By:
|
aldwinenriquez
|
Post Date:
|
2/21/2006 9:51:06 PM
|
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!"
|
|
