Something like this should work:
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:ns="http://www.cisco.com/AXL/API/8.0"> <soapenv:Header/>
<soapenv:Body>
<ns:executeSQLQuery sequence="1">
<sql>
select numplan.* from numplan,device,devicenumplanmap where numplan.tkpatternusage=5 and devicenumplanmap.fkdevice=device.pkid and devicenumplanmap.fknumplan=numplan.pkid and device.name like '10.9%'</sql>
</ns:executeSQLQuery>
</soapenv:Body>
</soapenv:Envelope>