How to split column value to columns SQL via select statement

Question

I have a table like this

ID   COACODE
-------------------
1    10200001

I want select statement split it like

ID   BR  DEPT  MINS
-------------------
1    10  2000  01

`SUBSTRING()` function will help you if column length in table is fixed — Mudassir Hasan, Jul 19 '16 at 06:36
See if this helps (http://stackoverflow.com/questions/27202408/to-split-numbers-using-sql-server) — VortixDev, Jul 19 '16 at 06:39
SELECT SUBSTRING(COACODE, 1, 2) as BR , SUBSTRING(COACODE, 3, 6) as DEPT , SUBSTRING(COACODE, 7, 8) as MINS — JYoThI, Jul 19 '16 at 06:40

score 1 · Accepted Answer · answered Jul 19 '16 at 06:46

The SUBSTRING functions allows you to extract a substring from a string.

NOTE: its works on when each row have same length of value otherwise it makes error

SELECT ID,SUBSTRING(COACODE, 1, 2) as BR , SUBSTRING(COACODE, 3, 6) as DEPT , SUBSTRING(COACODE, 7, 8) as MINS from table_name

1 Answers1