i have a text box with a search button.on the click of button i want to fetched all the values start with any alphabet say 'm' and bind to grid view.i hv used a query

sqlcommand cmd=new sqlcomand("select * from table where pname='"+textbox1.text+"'%",con);

but it shows that invalid term % how to do this

pls help me

regards

rajeev