% 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

Expand|Select|Wrap|Line Numbers

select * from [tablename] where [columnName] LIKE '%%'

but i want the value to be taken from the textbox.

Expand|Select|Wrap|Line Numbers

 select * from [tablename] where [columnName] LIK '% + search.text + %'
 

OuTCasT

hi guys nvm i got the solution

Expand|Select|Wrap|Line Numbers

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

Thanks anyways

ck9663

Build your query from your apps.

-- CK

% WildCard

re: % WildCard

re: % WildCard

Similar Microsoft SQL Server bytes

/bytes/development

/bytes/it

/bytes/about