[thelist] Stored procedure

[Stevenson Ngila]

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