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