search table + sql

[costavo]

hi all, i have a value entered by user into a text box, i want to search the table for the detail of the entered text. plz provide me with the syntax to do such thing Regards

[John ph]

you need to use LIKE operator to search for a given string. SELECT Column1,Column2 from Table1 where SearchColumn LIKE '%' + @SearchString + '%' hope this helps...

---

Regards
John

---

[Rami Said Abd Alhalim]

this solution if you use string Select * from tableName where ColumnName = '"+textbox.text+"' this solution if you use integer Select * from tableName where ColumnName = '+textbox.text+' Rami Abdalhalim