I have a stored procedure containing the following,
SELECT @cntctownerkey = (SELECT CustKey FROM tarCustomer WHERE CustName = @account)
However, it does not return a value because value of @account contains a single quote. How can I handle this given I can't escape the quote because I do not know if/when one will occur in @account?