SELECt UserID, CASE WHEN EXISTS ( SELECT 1 FROM dbo.Users WHERe UserPeers LIKE '%' + u.UserID + '%') THEN 'I am in Column1' ELSE UserID ENDFROM dbo.Users AS u;
SELECt UserID, CASE WHEN EXISTS ( SELECT 1 FROM dbo.Users WHERe UserPeers LIKE '%' + u.UserID + '%') THEN 'I am in Column1' ELSE UserID ENDFROM dbo.Users AS u;
名师互学网 版权所有 (c)2021-2022 ICP备案号：晋ICP备2021003244-6号
