Using a textbox as a variable

[levyuk]

Hi
I have this code

cmdSelect = New OleDbCommand( "SELECT [recipes].[ID], [recipes].[Name] FROM [recipes] WHERE Name LIKE 'a%'", conNorthwind )

What I would like to do is change the LIKE part so that the variable to search by is equal to some text from a textbox e.g.

cmdSelect = New OleDbCommand( "SELECT [recipes].[ID], [recipes].[Name] FROM [recipes] WHERE Name LIKE '" & TextBoxName.Text "%'", conNorthwind )

Does anyone know how to do this?

 

[levyuk]

Solved it

cmdSelect = New OleDbCommand( "SELECT [recipes].[ID], [recipes].[Name] FROM [recipes] WHERE Name LIKE '" & TextBox1.Text & "%'", conNorthwind )