sql - How to replace Unit Separator in for xml auto query -

i want replace xml unit separator in columns in table.

this query:

select *     [tablename] t     xml auto, type  

so far, great, once parse xml, got error because apprently 1 of rows got unit separator in it.

is there way replace unit separator directly in query?

do need unit separator? can't remove them predicate?

select clientno, replace(email,``,``) email, [other columns... ] [tablename] t     xml auto, type   

edited change:

; t (     select clientno, replace(email,``,``) email, [other columns... ]     [tablename]  )  select *  t xml auto, type