Convert XML file to separate columns in SQL

SUGGESTED

Good day

We receive an XML string from a client but it is not the correct format for Sage X3. Is it possible to write the data from this string into its own separate columns in SQL?

Regards

Chris