From my limited knowledge, I understand that this
select companyName, companyState from companyDetails where freetext(companyName, '"eagle*"') and companyState = 'WA' order by companyName is going to return exact matches, the reason being is that if double quotes surround the phrase then you are telling the t-sql to do an exact match. So have you tried select companyName, companyState from companyDetails where freetext(companyName, 'eagle') and companyState = 'WA' order by companyName Andrew Scott Senior Coldfusion Developer Aegeon Pty. Ltd. www.aegeon.com.au Phone: +613 8676 4223 Mobile: 0404 998 273 No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.476 / Virus Database: 269.10.0/886 - Release Date: 4/07/2007 1:40 PM --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~----------~----~----~----~------~----~------~--~---
