call.sql

USE [UUSurvey]
GO

DECLARE	@return_value int

EXEC	@return_value = [dbo].[Search_AlleCursussenActief_Opleiding]
		@Q = N'INFO'

SELECT	'Return Value' = @return_value

GO

-- This still contains rows with CourseName = 'WIS...'  not good!

procedure.sql

CREATE PROCEDURE Search_AlleCursussenActief_Opleiding (@Q nvarchar)
AS
BEGIN
	SET NOCOUNT ON;
	SELECT DISTINCT c.*, opl.OPLEIDING AS Programme, opl.NaamEn AS ProgrammeNameEN, opl.NaamNL AS ProgrammeNameNL, opl.TypeOpleiding AS [Type]
	FROM [dbo].Cursussen AS c, [dbo].Opleidingen_Cursussen AS opl
	WHERE
		c.StartDate <= CURRENT_TIMESTAMP AND c.EndDate >=  CURRENT_TIMESTAMP AND
		c.CourseName = opl.CURSUS AND opl.Faculteit = c.Faculty AND
		c.CourseName LIKE '%' + @Q + '%'
	ORDER BY c.CourseName
END

query.sql

	SELECT DISTINCT c.*, opl.OPLEIDING AS Programme, opl.NaamEn AS ProgrammeNameEN, opl.NaamNL AS ProgrammeNameNL, opl.TypeOpleiding AS [Type]
	FROM [dbo].Cursussen AS c, [dbo].Opleidingen_Cursussen AS opl
	WHERE
		c.StartDate <= CURRENT_TIMESTAMP AND c.EndDate >=  CURRENT_TIMESTAMP AND
		c.CourseName = opl.CURSUS AND opl.Faculteit = c.Faculty AND
		c.CourseName LIKE '%INFO%'
	ORDER BY c.CourseName

-- This gives the correct result