1
Answer

Split String Data

MANISH RFS

MANISH RFS
2y
812
1

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

Answers (1)
Next Recommended Forum