Hi All

Running ASA 9.0.2.3661, I have a situation where one of the fields
(varchar(4000)) with a table contains an xml string as shown below.

<ROOT><NEW_DATA sys_key="Audit_id" value_integer="1056"
value_decimal="" Value_DateTime="" value_string=""
value_desc="Integer: Next session ID of user in UAUDIT table"/></ROOT>

In my select statement I would like to extract the value_integer value
1056.

can someone help with the correct command?

Thanks

Roger

The OPENXML function might help, you should check out the docs related
to this function:
http://www.ianywhere.com/developer/p...9/00000243.htm

Roger Peffers wrote: