select SUBSTRING(CWAREHOUSE_LOCATION_CODE,6,4) from DEMO2

select left(CWAREHOUSE_LOCATION_CODE,4) from DEMO2

select right(CWAREHOUSE_LOCATION_CODE,4) from DEMO2