SQL Error for roles with single quote

At login, if the role has a single quote, it gets inserted fine. But, at the next login when it does a select for that role, it has an error at the single quote, because it is not escaping it. Then, it throws a second error message, because it tries to insert that role again and has a duplicate key error (this time it is escaped).

Thanks,
Shane