Hi to all,
My TABLE data is ,
ABCD > EFGH > IJKLMNOP > QRS > TWX9GG
ABCD > EFGH > XYZ > GH
ABCD > EFGH > GHJK > I45EDBDGG
BUT ABOVE DATA I HAVE TO MOVE AS A SAPARATE COLUMN BASED ON ">" DELIMTOR
COL1 COL2 COL3 COL4 COL5
ABCD EFGH IJKLMNOP QRS TWX9GG
ABCD EFGH XYZ GH SD
ABCD EFGH GHJK I45EDBDGG
How it possible ,it is not a Fixed width .
Any one please help me this scenario
Classic: Recursive query.
New (sort of): Use STRTOK (if there is a max number of 'columns').