I Have String Wise Data In table
My Out put Look Like
. 
i have write Query
SELECT
REVERSE(PARSENAME(REPLACE(REVERSE(Data1), '|', ','), 1)) AS BatchQty
, REVERSE(PARSENAME(REPLACE(REVERSE(Data1), '|', ','), 2)) AS Qty
,Data1
FROM RFS21_HeatChargeSplitRec
But Output Column (BatchQty,Qty)Return Null
Thank In Advance