November 8, 2006 at 9:13 pm
Just as the title suggests, how do I ignore punctuation in an SQL query using full txt searching?
Say if I wanted to search on:
O'brien
or
Mary's Hat.
I would expect that the search engine would look for:
Obrien OR O'brien
and
Marys hat OR Mary's Hat.
Im using SQL 2005
November 10, 2006 at 6:43 am
Hi Mark,
You're best bet is to run the search input through a function that replaces all punctuation with '%' to give you a string that is suitable for the like operator.
Good luck!
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy