Search anomaly

10 years ago
The Search function does not seem to find names containing an apostrophe such as O'Brien and O'Shea. It does find the relevant item under Brien and Shea respectively though. Is there a workaround for this?
10 years ago
Maybe you could create a function that recognizes any characters like (') and insert (\) before the character.  This will tell the SQL server that (') is a literal character.

Something like: SELECT * FROM Nop_Product WHERE (Name LIKE 'O\'Brien%')

This is untested but I hope it helps.
3 weeks ago
is there a solution without programming?