I'd like to extract the list of emps from the following XML where name starts with 'Jo' (returns Jones, Johnson). In SQL I can use the expression 'where name like 'Jo%'.
Anyone have examples of how this be done via an E4X expression (I could not find any examples of this in the docs). TIA, Patrick <mx:XMLList id="emplist"> <emp> <id>1</id> <name>Smith</name> <mrn>1000</mrn> <dob>1/1/1964</dob> </emp> <emp> <id>2</id> <name>Jones</name> <mrn>1001</mrn> <dob>11/11/1951</dob> </emp> <emp> <id>3</id> <name>Johnson</name> <mrn>1003</mrn> <dob>3/3/1953</dob> </emp> </mx:XMLList>