Write a query for split one column to multiple columns

I have a source table with one column of 15 characters and I want output like divide the 15 chars column into multiple of 3 columns like every column 5 chars
source empnoorderprdct target empno order prdct

Showing Answers 1 - 2 of 2 Answers


  • Jun 5th, 2017

You can use Substring function to split the column values to 3 columns

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.


Related Answered Questions


Related Open Questions