I need a parameter where a user inputs a Movie Title and the the number of videos in the Inventory of that movie are displayed. WHen I put it in like this it tells me that there is a Error

Msg 156, Level 15, State 1, Procedure VideoByTitle, Line 1
Incorrect syntax near the keyword 'IN'.

I don't understand what I am doing wrong. I am doing it exactly like another example in the book. Any Ideas?

CREATE Procedure VideoByTitle (IN p_MovieName CHAR (20) )
SELECT t.MovieName, vi.TitleID
FROM VideoInventory vi, Titles t
WHERE vi.TitleID = t.TitleID AND t.MovieName = p_VideoTitle