BNV
New Contributor II

This might be a good start but I do get an error ("Invalid XPath") when trying to access the column as the xpath. Is it not possible to use a column as the xpath?

SELECT xpath(MyColumn.value'/XMLData/Values/ValueDefinition[@colID="10"]/@Value)[1]') as Remarks