How to write SP Advanced Search and or value

I have tables with empty or null fields

movies:

movie_Id	title	Image	actor
1		1.jpg	Bill Murray, Olivia Williams
2	Playing for Keeps	Playing.jpg	Gerard Butler, Jessica Biel
3	NULL	3.jpg	Felicity Jones
4	Heleno		NULL

Movie_Directors:

MovieDirectors_ID	movie_Id	director_Id	DirectorName
1	1	1	Roger Michell
2	1	2	Gabriele Muccino
3	3	3	Donald Rice
4	2	4	José Henrique Fonseca

                                              


 

This SP display nothing

ALTER PROCEDURE dbo.SP1

@title varchar(50)= NULL,
@actors varchar(100)= NULL,
@DirectorName varchar(50)= NULL
AS

SET NOCOUNT ON
SET TRANSACTION ISOLATION LEVEL READ COMMITTED

SELECT movies.movie_Id, movies.title, movies.image, Movie_Directors.DirectorName


FROM movies INNER JOIN

Movie_Directors ON movies.movie_Id = Movie_Directors.movie_Id

WHERE (movies.title = '' or movies.title LIKE '%' + isnull(@title,movies.title) + '%')
and (movies.actors= '' or movies.actors LIKE '%' + isnull(@actors,movies.actors)+ '%')
and (Movie_Directors.DirectorName= '' or Movie_Directors.DirectorName LIKE '%' + isnull(@DirectorName,Movie_Directors.DirectorName)+ '%')

I don't know why!!!

Please help me

Hi

as per your query groupby not working, group by working with aggregate function.
Plz share what type of data you want.

sorry u are rightmy sp:

SELECT movies.movie_Id, movies.title, movies.image, Movie_Directors.DirectorName
           

FROM            movies INNER JOIN

                         Movie_Directors ON movies.movie_Id = Movie_Directors.movie_Id

WHERE        (movies.title = "" or movies.title LIKE '%' + @title + '%') and (movies.actor= "" or movies.actor LIKE '%' + @actor+ '%')and (Movie_Directors.DirectorName= "" or Movie_Directors.DirectorName LIKE '%' + @DirectorName+ '%')

Group by DirectorName

Hi
  friends
I think something is missing where is Gridview data source and one more thing is added why are used the cross word. Plz clear doubt before move to ahead.