HOW to find a bad XML syntax in varchar column

Database
Enthusiast

HOW to find a bad XML syntax in varchar column

Hi,

i'm trying to find a needle in a haystack with XML in a varchar: CREATEXML(column) returns an error 9134 when reading 80 000 lines,

and no error when sampling. 

I suppose some lines have a varchar column with incomplete XML syntax or false syntax ?

How to find those lines ? 

Description is as plain as <PROPS><PROP NAME="NUM_xx" VALUE="100"/><PROP NAME="ID_xx" VALUE="1"/> ....

running under V15.00

 

Thanks for help,

Pierre