How to get all hits with apostrophe and colon? Example: Andersons, Anderson's, Anderson:s, Andersons'
Posted on 2008-10-23
In Sweden we have no special genitive characters i.e. Anderson's cat is just written Andersons cat (or Andersons katt in Swedish). But some companies write their names with apostrophe ' and sometimes even colons i.e. Anderson's or Anderson:s (or Mc Donald's for example).
In our company name SQL query we use a combination of ordinary search and full text search with the "contains("formsof thesaurus")". When searching for andersons, no hits for anderson's or anderson:s are returned and this is our problem. Likewise when search for example anderson's, no hits for andersons (or anderson:s) are returned.
I have tried to set this in the thesaurus file but it seems to just consider whole words and it is not working for example to set <sub>s</sub> <sub>'s</sub> <sub>:s</sub>.
One way would be to check the incoming search word(s) programatically for apostrophes or colons and do a search for each. That is; if @searchWord= Anderson's then search for Anderson's then replace the apostrophe to a colon and search for Anderson:s and then remove the colon to search for Andersons but this doesn't seem to be a good solution performance wise...?
Another way would be to put <sub>Andersons</sub> <sub>Anderson's</sub> <subAnderson:s></sub> in the full text search thesaurus file but this is not a realistic solution since there are so many variants; Svenssons, Peters, Harrys etc. etc. to be set in that file.
How do I solve this problem?