% WildCard

[OuTCasT]

Hi guys.

id like a gridview to display the results from the textbox search, but i want it to search the db for anything i type in and match it.

sort of like

[CODE=sql]select * from [tablename] where [columnName] LIKE '%%'[/CODE]
but i want the value to be taken from the textbox.

[CODE=sql]select * from [tablename] where [columnName] LIK '% + search.text + %'[/CODE]

[OuTCasT]

hi guys nvm i got the solution

[CODE=sql]Select * from [tableName] where [ColumnName] LIKE ('%' + @search + '%')[/CODE]

Thanks anyways

[ck9663]

Build your query from your apps.

-- CK