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?
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%')
