Following code will do the trick;
DECLARE @topsql nvarchar(200)
SET @topsql =
'DECLARE @quotedvar nvarchar(100) ' + char(13) +
'DECLARE @sql nvarchar(1000) ' + char(13) +
'SET @quotedvar = ''O''''Neil'' ' + char(13) +
'SET @sql = ''PRINT '''''' + REPLACE(@quotedvar,'''''''','''''''''''') + '''''''' ' + char(13) +
'PRINT @sql ' + char(13) +
'EXEC sp_executesql @sql '
PRINT @topsql
PRINT '-------'
EXEC sp_executesql @topsql
Thanks, Hasham Niaz