I need help in fetching records using a stored procedure, where I need to pass a single parameter from the stored procedure, but I need to fetch both semester records 

```
Declare @sem varchar(10)

set @sem ='1sem'

```

Ex: select \* from student where TestType = '1sem'

```
set @sem ='2sem'
select * from student where TestType = '2sem'

set @sem ='dual'

```

If I need to select both 1st sem and 2 sem, I have only one parameter but how to handle it with the stored procedure.

```
Select * 
from student 
where TestType where?

```

How can I achieve 

```
select * 
from student 
where TestType = '1sem' or TestType = '2sem'

```