Can anyone help me with a SQL string ? or point me in the right direction?
I have a colum called ctn_node_path which has results like
PARTS & ACCESSORIES > PSJOHNSON - SEDDON JOHNSON PARTS > JN - JOHNSON PARTS
I am trying to split the string into three
PARTS & ACCESSORIES
SJOHNSON - SEDDON JOHNSON PARTS
JN - JOHNSON PARTS
I am using RTRIM(LEFT (ctn_node_path, CHARINDEX(' > ',ctn_node_path, 0))) to get the first part of the string
however getting Function argument count error can anyone help?