Incorrect Syntax - Error Help

Hi! I need some help with this error which I'm unable to understand.

Any help will be highly appreciated.

<Error>
Line 1: Incorrect syntax near 'Number'.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Line 1: Incorrect syntax near 'Number'.

Source Error:

Line 69: Dim da As SqlDataAdapter = New SqlDataAdapter(cmd)
Line 70: Dim ds As DataSet = New DataSet
Line 71: da.Fill(ds, "Equip")
Line 72:
Line 73: dgdSearch.DataSource = ds.Tables("Equip").DefaultView

Source File: c:\inetpub\wwwroot\Equip log\Demo\WebForm3.aspx.vb Line: 71

Stack Trace:

[SqlException: Line 1: Incorrect syntax near 'Number'.]
System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)
System.Data.SqlClient.SqlCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
System.Data.Common.DbDataAdapter.FillFromCommand(Object data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable)
Demo.WebForm3.butSearch_Click(Object sender, EventArgs e) in c:\inetpub\wwwroot\Equip log\Demo\WebForm3.aspx.vb:71
System.Web.UI.WebControls.Button.OnClick(EventArgs e)
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument)
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument)
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)
System.Web.UI.Page.ProcessRequestMain() +1292

</Error

Private Sub butSearch_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles butSearch.Click
 Dim objConnection As SqlConnection
 Dim objCommand As SqlCommand
 Dim objAdapter As SqlDataAdapter
 Dim objDataReader As SqlDataReader
 Dim objDataSet As DataSet
 Dim strSearch As String
 Dim StrSQLQuery As String
 'Dim mySQL As String
 'Get Search
 strSearch = txtSearch.Text
 'If there's nothing to search for then don't search
 ' o/w build our SQL Query execute it.
 If Len(Trim(strSearch)) > 0 Then
 'Set up our connection.
 Dim strConn As String = ("server=(local);Integrated Security=SSPI;database=Equipment Log")
 '-- setup the select command
 Dim mySQL As String = "Select * From Equip Where " & ddlSearch.SelectedValue.ToString() & " Like '" & txtSearch.Text & " %' Order by DemoNum"
 Dim MyConn As New SqlConnection(strConn)
 '--create the SqlCommand object (a connection would need to be set up too)
 Dim cmd As SqlCommand = New SqlCommand(mySQL, MyConn)
 MyConn.Open()
 '--execute the query and fill a dataset with the results
 Dim da As SqlDataAdapter = New SqlDataAdapter(cmd)
 Dim ds As DataSet = New DataSet
 da.Fill(ds, "Equip")
 dgdSearch.DataSource = ds.Tables("Equip").DefaultView
 'Create new command object passing it our SQL Query
 'and telling it which connection to use.
 objCommand = New SqlCommand(strSearch, objConnection)
 'DataBind DG to DS
 ddlSearch.DataBind()
 dgdSearch.DataBind()
 MyConn.Close()
 Else
 txtSearch.Text = "Enter Serach Here"
 End If

I am assuming that ddlSearch.SelectedValue.ToString() returns the string "number". Number is a reserved word in SQL Server, so as such it needs to be enclosed in square brackets when it is used as a column name. Try this instead:

Dim mySQL As String = "Select * From Equip Where [" & ddlSearch.SelectedValue.ToString() & "] Like '" & txtSearch.Text & " %' Order by DemoNum"

Terrisql