Case sensitive for Sql select in Sql Server

Create PROCEDURE  SelectDetails
(
@Name varchar(30)
)
AS
BEGIN

    if (select name from  Student where Name=@Name ) is NULL
begin

SELECT       Name, Age ,Address    FROM   Student where Name=@Name
COLLATE  SQL_Latin1_General_CP1_CS_AS

        end