hi all, I want to run a stored procedure sp_testing @sDescription as ntext where @sDescription is:- 'steve and 'john' went on a trip'. But John is in quotes and this data is feed automatically, how can i make this run. i have tried using sp_testing replace (@sDescription, '''', '''''') as ntext, but it's failing. Please assist