I need to use a BindingSource Filter property to search for names in a string field. That is easy enough, unless the name contains a single quote (apostrophe) such as "O'BRIEN" or similar names. VS Help says special characters should be escaped by enclosing them in square brackets. This works for some characters such as %, \ and even the bracket characters themselves, but it fails with a syntax error if I attempt to escape a single quote. I also tried to escape using \ but that doesn't work either.
Does anyone know of a way to use expressions to search for strings containing single quotes?