Reply to thread

Message: <blockquote data-quote="levyuk" data-source="post: 1654" data-attributes="member: 114">HiI have this code[CODE]cmdSelect = New OleDbCommand( "SELECT [recipes].[ID], [recipes].[Name] FROM [recipes] WHERE Name LIKE 'a%'", conNorthwind )[/CODE]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?</blockquote>