Stored Procedure

How to write stored procedure for this
select * from TABLE1 where firstname like '" + txtbox1.text + "%'
...