SELECT [schoolname] AS combinationschools, 
       CASE 
         WHEN [schoolname] LIKE '%/%' THEN (SELECT value 
                                            FROM 
         [dbo].[Split]('/', '#6/#9E/#9M')) 
       END          AS schoolname 
FROM   [dbo].[schools];

我正在像明智的那样获得q sql错误-

子查询返回了1个以上的值。当子查询遵循=，！=，<，<=，>，> =或将子查询用作表达式时，不允许这样做。