SQL: Extracting values from XML field

Hi All,

I need to extract a value from PcValueSet.FieldValues, which is an XML field, for a particular input from our configurator.

I’ve been searching Google for answers, as this is a SQL Server feature, but I was wondering how Epicor users are handling it because I’m seeing several different ways online.

Any feedback or SQL examples would be appreciated.

Joe Rojas

Epicor Application Manager

Nordson MEDICAL

261 Cedar Hill Street

Marlborough, MA 01752 USA

+1.508.597.1392
**Phone
**+1.774.826.9245 Mobile

joseph.rojas@nordsonmedical.com

Quality Works Here