• How about using Quotename...?

    SELECT QUOTENAME('o''neil', '''')