SQL字段分隔函数

ALTER FUNCTION [dbo].[Fun_SplitStr]
(
    @val      VARCHAR(8000), --要分割的字符串
    @split varchar(100)  --分隔符号
)
RETURNS @temp TABLE(Result VARCHAR(100))
AS
BEGIN
    DECLARE @result AS VARCHAR(100);   --定义变量用于接收单个结果 

    SET @val = @val + @split ;  

    WHILE (@val <> '')
    BEGIN
        SET @result = LEFT(@val, CHARINDEX(@split, @val, 1) -1) ;  

        INSERT @temp VALUES(@result) ;  

        SET @val = STUFF(@val, 1, CHARINDEX(@split, @val, 1), '');
    END 
    RETURN
END

–使用方法

select Result 
from dbo.Fun_SplitStr('28869d31db53fcbbcdb26129ae57b5ac;85b24fc3d3bbfe5e192731c1ab4b92d3;',';')