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