DECLARE @str varchar(1000)DECLARE @idoc int;DECLARE @doc xml; set @str='1&brvbar;3&brvbar;4&brvbar;25'set @doc=cast('<Root><item><ID>'+replace(@str,'&brvbar;','</ID></item><item><ID>')+'</ID></item></Root>' as xml) EXEC sp_xml_PReparedocument @Idoc OUTPUT, @docSELECT *   FROM OPENXML (@Idoc, '/Root/item',2)WITH ([ID] varchar(10))  /**//*ID-----------13425*/