- CREATE FUNCTION [dbo].[svf_IsExistDataList] (
- @SearchString nvarchar(MAX),
- @DataLists nvarchar(MAX),
- @Delimiter nvarchar(MAX) = N','
- )
- RETURNS BIT
- AS
- BEGIN
- RETURN
- CASE WHEN (CHARINDEX(@SearchString, @DataLists) > 0
- AND (@DataLists = @SearchString
- OR @DataLists LIKE @SearchString + @Delimiter + N'%'
- OR @DataLists LIKE N'%' + @Delimiter + @SearchString + @Delimiter + N'%'
- OR @DataLists LIKE N'%' + @Delimiter + @SearchString)
- )
- THEN 1
- ELSE 0
- END
- END