字符串切割、截取

 

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

 

posted @ 2021-08-30 08:09  一块冷牛排  阅读(79)  评论(0)    收藏  举报