T-SQL筆記53_將某一字串欄位針對特定字元split成兩欄位作法_使用charindex與substring

T-SQL筆記53_將某一字串欄位針對特定字元split成兩欄位作法_使用charindex與substring

- 8月 23, 2023

程式

DECLARE @tbl TABLE(Column1 VARCHAR(100))

INSERT INTO @tbl
SELECT '1/1' UNION ALL
SELECT '1/20' UNION ALL
SELECT '1/2'
select * from @tbl

SELECT
    SUBSTRING(tbl.Column1,0, CHARINDEX('/',tbl.Column1) ),SUBSTRING(tbl.Column1,CHARINDEX('/',tbl.Column1)+1,LEN(tbl.Column1))
FROM
    @tbl AS tbl

留言