Add to the FULL TEXT INDEX a REGULAR EXPRESSION ability
My requirement comes from having to find all records in a table of documents in which there is a field "Title" and "DocumentText" through a FULLTEXT search, but in most cases the search is to find documents that contain an item number. This item code is an alphanumeric variable composition but may be correctly recognized by a regular expression.
Actually I must search through the exact expression LIKE '%item%' with very poor performance.
Upvotes: 3<=-=Feb 25 2011 10:27AM=-=>
Thanks for your suggestion for improving the Fulltext Search Featureset. This is an often requested feature and is on our radar for improvements in future releases. At this stage unfortunately we can not provide any timeline on its availability.
Microsoft SQL Server Search Group