SELECT XMLELEMENT(name "row", XMLELEMENT( NAME "Description", REPLACE(REPLACE(REPLACE( REPLACE(REPLACE(REPLACE( REPLACE(REPLACE(REPLACE( REPLACE(REPLACE(REPLACE( REPLACE(REPLACE(REPLACE( REPLACE(REPLACE(REPLACE( REPLACE(REPLACE(REPLACE( REPLACE(REPLACE(REPLACE( REPLACE(REPLACE(REPLACE( REPLACE(t.description, /* \x0e-\x1f*/ CHAR(31), ''),CHAR(30), ''),CHAR(29), ''), CHAR(28), ''),CHAR(27), ''),CHAR(26), ''), CHAR(25), ''),CHAR(24), ''),CHAR(23), ''), CHAR(22), ''),CHAR(21), ''),CHAR(20), ''), CHAR(19), ''),CHAR(18), ''),CHAR(16), ''), CHAR(15), ''),CHAR(14), ''), /* \x0b-\x0c */ CHAR(12), ''),CHAR(11), ''), /* \x00-\x08 */ CHAR(8), ''),CHAR(7), ''),CHAR(6), ''), CHAR(5), ''),CHAR(4), ''),CHAR(3), ''), CHAR(2), ''),CHAR(1), ''),CHAR(0), '') ) ) FROM AbacBill.dbo.InitialTicketsImport t