need select query

Question

  i need select query for my data base. suppose i have 100 records in my database and i want to search records with a or b.

 

or any any other character.selection is done by textboxes i am writing this code

 

select * from student_table where name ="@name"

cmd.parameters.addwithvalue("@name",txtname.text);

 

 

now if i press  s then records starts with s sholud display but not those records in which s is not the first word e.g.

 sahil

siddharth

siddhu

rajesh

suraj

bhansali

rishab,james,kailash

suresh

 

i need a query to display records like sahil,siddhu,suraj ,siddharth,suresh not the other ones.