I have a problem with queryXMLNode, I have the following example:
//ITEM[MA_TRAN_TYPE=1 and (MA_CVE_VTA!= ‘00001’)]
the problem is when in file xml there are tags MA_CVE_VTA with blank spaces both sides, for example, if i apply previos xquery in this xml:
<MA_CVE_VTA> 000001 </MA_CVE_VTA>
My query doesn’t work, because this MA_CVE_VTA appears in my final result , it’s not must happens, but when I remove blank spaces the query the query is OK.
Anyone knows some function for remove blank spaces from XML tag?