select 'select distinct ''' || a.name || '.' || b.name
|| '''  from ' || b.name
|| 'where ' || b.name || ' like ''%<%/>%'' union '
from systable a
join syscolumns b on (a.id = b.id)
join systypes c on (b.type = c.xtype)
where a.type ='U' and c.name = ('CHAR', 'CHARN', 'VARCHAR', 'VARCHARN');

select * from information_schema.columns
where DATA_TYPE = 'XML'