select XMLCAST(xmlquery('$c/Properties/Properties/@name' passing item_xml as "c") as varchar(400)) from t_test_item