Parameters and SqlDataAdapters...

[CaroleR]

I have a query like so, "select items from ItemList where itemID like 'I1 02.507%'<BR><BR>In sql analyser, this runs fine, but when I pass the string<BR>'I1 02.507' to my code and set the value of <BR>parameterDesc.Value = http://aspmessageboard.com/archive/index.php/item_number_textbox.Text + "%";<BR>myDA.SelectCommand.Parameters.Add(parameterDesc);<BR> then run it, it fails(return no records when I should get hundreds) any thoughts?<BR>-M