I have a scenario where I want user to input data for search.  Statement
looks like
Select course_nbr, attend
From table_1
Where (course_nbr = @course_nbr)

This only allows user to input exact course number and then the query will
return a result.  

I want to be able for user to input the first few letters of the course
number and the query should return all course numbers that starts with those
letter.

Any help would be greatly appreciated.

Shan