I'm trying to speed up a wildcard search on a text field along the lines of SELECT companyName from companyDetails where companyName like '%eagle%'
The database is mssql 2005 and the table has over two million rows. What I have already done is to create a full-text index on companyName and while it does appear to run faster, the results generated by the query using the full-text index aren't even nearly the same as the results of the wildcard query in that the wildcard search picks up 'eaglehawk' but the full-text query doesn't, even using "eagle*". Can anyone explain this for me or point me to a reference that will help? Thanks and sorry for the OT but I thought other people here might be interested. Brett B) --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
