Hello SQL Expert,
I am trying to split the string value between string as Field_1 and Field_2, but some of the value has no comma. So any values that do not have comma will be skipped.
How do I string manipultaion in SQL?
So for example:
Column_A
ABC,DEF
ACD,FGH,
ADFGFH,CV
HHHH,CG
HHHKKK01
JUHUHG1112
So I need to split the value of Column A as
Column_A FIELD_1 FIELD_2
ABC,DEF ABD DEF
ACD,FGH ACD FGH
AD,GGFG AD GGFG
HHHH,CG HHHH CG
HHKF2231
JUH00122
Thanks guys