spNetGroup_Search

        CREATE PROCEDURE [dbo].[spNetGroup_Search]
        (
        @DisplayName nvarchar(100)
        )
        AS

        SELECT
        ID
        FROM [NetGroup]
        WHERE DisplayName LIKE '%' + @DisplayName + '%'
        AND Deleted = 0 AND PublishInDirectory = 1


        RETURN