how to split a string and display it in different columns?

Question

Viewing 4 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Megha P SSCommitted Points: 1976 More actions · Answer 1

check below article

arrjay Hall of Fame Points: 3455 More actions · Answer 2

Is the string always consistent, if so you can use substring. i.e SELECT SUBSTRING('HELLO WORLD',4,5)

Result 'LO WO'

--------------------------------------------

Laughing in the face of contention...

peterausger Mr or Mrs. 500 Points: 544 More actions · Answer 3

yes it is consistent...

i tried substring its not giving the expected out in differnt columns..

arrjay Hall of Fame Points: 3455 More actions · Answer 4

can you post your code and some dummy values

--------------------------------------------

Laughing in the face of contention...