如何在SQL中将字符串拆分成列表进行过滤？

-- 创建存储过程
CREATE PROCEDURE SplitAndFilterString
    @inputString NVARCHAR(MAX),
    @filterCondition NVARCHAR(50)
AS
BEGIN
    -- 创建临时表
    CREATE TABLE #TempTable (
        Value NVARCHAR(50)
    )
    
    -- 拆分字符串并插入临时表
    DECLARE @delimiter CHAR(1) = ','
    DECLARE @startIndex INT
    DECLARE @endIndex INT
    SET @startIndex = 1
    
    WHILE @startIndex <= LEN(@inputString)
    BEGIN
        SET @endIndex = CHARINDEX(@delimiter, @inputString, @startIndex)
        IF @endIndex = 0
            SET @endIndex = LEN(@inputString) + 1
        
        INSERT INTO #TempTable (Value)
        VALUES (SUBSTRING(@inputString, @startIndex, @endIndex - @startIndex))
        
        SET @startIndex = @endIndex + 1
    END
    
    -- 进行过滤
    SELECT Value
    FROM #TempTable
    WHERE Value = @filterCondition
    
    -- 删除临时表
    DROP TABLE #TempTable
END

EXEC SplitAndFilterString 'apple,banana,orange', 'banana'