Search using textbox value and wildcard character

[www.Dome-Bonez.co.uk]

I want to search the empid of a name that with the characters entered in my textbox. using wildcard characters. I wrote the statement \[code\]da = new SqlDataAdapter( "Select empID from emp where FirstName like ' "+textbox1.text+" ' % " , connstring); da.Fill(ds);\[/code\]Is this statement correct?