Extracting individual fields from XML

[#1]

The data stored in MS SQL database column is an entire XML structure.

How to extract the individual fields of the xml from the column??

Regards,

Rishabh

[Former Member · Accepted solution]

Hi,

use extract_from_xml function which is under Conversion functions category  ,this function  will appear only when you select new function call in schema out

[Rishabh_Awasthi]

Thanks Michael