wasabi3689
asked on
how to get this number data?
I have a table in which there is a field stored XML data like below
<?xml version="1.0" encoding="UTF-8"?>
<note>
<to>Tove</to>
<from>Jani</from>
<heading>Reminder</heading >
<body>98765</body>
</note>
If I want to develop a script, only output the number like 98765, how to do that?
select *
from table
where field like 'number only'
<?xml version="1.0" encoding="UTF-8"?>
<note>
<to>Tove</to>
<from>Jani</from>
<heading>Reminder</heading
<body>98765</body>
</note>
If I want to develop a script, only output the number like 98765, how to do that?
select *
from table
where field like 'number only'
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.