I need to search for a name in a database - so far so good. However, when I come up with a name like O'Leary to search for, this causes a problem as obviously the ' character signals the end of the string to be searched for. My SQL code is below, how can I modify this to work as I need it to?
I am working in ASP / VBScript.
SELECT * FROM Artists WHERE aName = 'O'Leary' AND aStatus = 1