Yeah, the double quotes were something I found in a reference by Ben Forte.
That query returns 131, which is better but it still doesn't find 'eaglehawk'. But thanks! Brett B) Andrew Scott wrote: > 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 -~----------~----~----~----~------~----~------~--~---
