DECLARE @t TABLE(value VARCHAR(10),xml_1 XML)

INSERT INTO @T(value,xml_1)

VALUES('1+2','<root><s>1</s><s>2</s></root>'),

('3+4','<root><s>3</s><s>4</s></root>')

SELECT value,x.r.value('.','INT') AS s

FROM @t

CROSS APPLY xml_1.nodes('/root/s') AS x(r)

____________________________________________________

Deja View - The strange feeling that somewhere, sometime you've optimised this query before

How to get the best help on a forum

http://www.sqlservercentral.com/articles/Best+Practices/61537