As long as you don't mind incorrect results:

DECLARE @inputValue NVARCHAR(20)

DECLARE @student TABLE

(Id INT PRIMARY KEY IDENTITY(1,1),

StudentName NVARCHAR(50),

StudentResult INT)

INSERT INTO @student

VALUES( 'Hardy', 100), ('Rocky', 98), ('Panky', 99), ('Ardy', 99)

--Select 1

SET @inputValue = 'Hardy'

SELECT * FROM @student WHERE StudentName IN (@inputValue)

--Select 2

SET @inputValue = 'Hardy,Rocky'

SELECT * FROM @student WHERE CHARINDEX(StudentName, @inputValue) > 0

Ardy shouldn't be returned but it is.