I know this is a SQL query and really should be elsewhere but in case anyone knows the answer......
Can anyone tell me how to bring back the equivalent rows using CONTAINS and fulltext indexes that are brought back from the query: SELECT dc.* FROM DOCUMENT_SEARCH dc WHERE (dc.title LIKE '%Cowboy%') When I run SELECT dc.* FROM DOCUMENT_SEARCH dc WHERE CONTAINS(dc.title, '%cowboy%') I do not get rows where the title is "cowboys" and if I run: SELECT dc.* FROM DOCUMENT_SEARCH dc WHERE CONTAINS(dc.title, 'FORMSOF (INFLECTIONAL,cowboy)') I do get rows where it is "cowboys" but not the ones that are, say, "ecowboys" ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
