SQL LIKE反用

 USE [ECDev]
GO
/****** Object:  UserDefinedFunction [dbo].[sumDepartmentNameToString]    Script Date: 10/17/2011 20:04:21 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
Alter function [dbo].[GetTeamNamesSql]
(
   @DepartmentIDs varchar(max)--部门ID字符串
)
Returns nvarchar(max)
as  
 begin 
          declare @DepartmentNames varchar(max)
          SELECT @DepartmentNames=
          case when @DepartmentNames is null then [Name] else @DepartmentNames+','+[Name] end
          from Pcitc_PC_Department_T
          where @DepartmentIDs like '%'+convert(varchar(50),ID)+'%'
          return @DepartmentNames 
 end

 

 

 

select USEUnIT,dbo.GetTeamNamesSql(USEUnIT) as DepartmentNames from ec_tevaluationReport

摘自电子商务ECDev数据库