Read XML value

i modified the query according to your xml file

create table #temp (xml_data xml)

insert into #temp values
('
[email protected]
[email protected]
Alert: Amounts donâ€™t match
117
sd')

select xml_data.value('(/commdef/field/.)[4]', 'varchar(10)') as [LockboxID] from #temp

any problem reply

if its help you mark it as answered

Ajitender Vijay13y ago

Hi Sanjeed, This query is not working it return NULL

Sanjeeb Lenka13y ago

check this query

select xml_data.value('(/commdef/LockboxID/.)[1]', 'varchar(10)') as [LockboxID] from tabelname

or for any help check this link

http://stackoverflow.com/questions/15846990/extracting-attributes-from-xml-fields-in-sql-server-2008-table

Ajitender Vijay13y ago

Hi lftikar, I need a SQL query to get that value

Iftikar Hussain13y ago

Hi,
Please provide more details. Are you trying to read the XML value in ASP.NET or SQL?

Regards,
Iftikar