Hi,
I need to embed single quotes in an sp string to SQL Server 2k, e.g. "O'Mally", and cannot for the life of me remember how. I'm sure I've done it in the past. At least I *think* I'm sure I've done it before! Anybody know how?

Gary