Relative Content

Tag Archive for sqlvbaapostrophe

SQl to search for text string of word with an apostrophe

My VBA/SQL code searches customer comments (in a table) for keywords (from Keywords table) and loops through the keywords. That works perfectly for words without apostrophes (contractions like: can’t, don’t, didn’t, etc.) I now need to be able to search for contractions in addition to regular words like: slow, lost, terrible. Here’s my code that works great for regular words: