Data Set Question about SQL Query

[tenno]

ASP.net 2.0 (VB):

While creating a new data set in design mode, I'm using the query builder and trying to write a query within "LIKE" for example:

SELECT * FROM table WHERE field LIKE @'%TextBoxData%'

but this query doesn't work...any clue to make it work? I mean using query builder in design mode...

[$.02]

Remove the @ sign...
SELECT * FROM table WHERE field LIKE '%TextBoxData%'

[tenno]

No, i don't want hard code the textbox value, i want a flexible value

[HairyMonkeyMan]

Who said anything about hardcoding values?

Use the @ symbol to denote a variable..

Maybe this is what you want?SELECT * FROM table WHERE field LIKE %@TextBoxData%

where @TextBoxData is your variable.

[tenno]

Maybe this is what you want?SELECT * FROM table WHERE field LIKE %@TextBoxData%

where @TextBoxData is your variable.

I tried that before, it's don't work either, error in building query

[HairyMonkeyMan]

what DBMS are you using?

[tenno]

SQL server 2005

[tenno]

Ok ladies and gentlement, finally i found the solution, let's learn this elite technic:

SELECT * FROM table WHERE field LIKE '%' + @TextBoxData.Text + '%'