So this is your original data:
The' Big -- Blue Fox 'Jumped Over the fen'ce but couldn't
Turn off quoted identifer and add a double quote at the beginning and end works for this example.
[font="Courier New"]SET QUOTED_IDENTIFIER OFF
declare @myVar varchar(100)
set @myVar = "The' Big -- Blue Fox 'Jumped Over the fen'ce but couldn't"
select @myVar as result
result
----------------------------------------------------------
The' Big -- Blue Fox 'Jumped Over the fen'ce but couldn't
(1 row(s) affected)[/font]
/Kenneth