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>