nice article. thanks.

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