you can create a fuction to remove this ,just
create FUNCTION [FN_REMOVE_SPECIAL_CHARACTER] (
@INPUT_STRING varchar(300))
RETURNS VARCHAR(300)
AS
BEGIN
DECLARE @NEWSTRING VARCHAR(100)
SET @NEWSTRING = @INPUT_STRING ;
With SPECIAL_CHARACTER as
(
SELECT '|' as item
)
SELECT @NEWSTRING = Replace(@NEWSTRING, ITEM, '') FROM SPECIAL_CHARACTER
return @NEWSTRING
END
run this Fuction on your query window
and pass your string.
select dbo.[FN_REMOVE_SPECIAL_CHARACTER] ('US Mail (9.50)|First Class Mail (Canada) (15.00)|Airmail (International Addresses) (26.00)|+Next Day Air (16.00 + 28.66 = 44.66)|UPS 2ND Day (11.00 + 17.44 = 28.44)|UPS Ground (10 + 9.29 = 19.29)|UPS NEXT DAY AIR (10.00 + 17.44 = 27.44)')