I'm trying to add a simple keywords search to my ojbect datasource and am having trouble with the syntax. I basically want to say 'select * from xyz where Description like '%The keywords from textbox%'. How do I represent the "%" character in my SelectCommand?
It works fine when I put: Description = @Keywords, but I need the "%"s.
I tried the following which didn't work:
"Description like '%@Keywords%'"
Here's my complete SelectCommand:
SelectCommand="SELECT [RecID], [TrackTitle], [Composer], [Filename], [Popularity], [Time], [Description], [Category], [SubCategory], [Keywords], [BPM], [CDTitle], [IsVocal] FROM [metadata] WHERE Composer like @Artist AND Status = @Status AND Description like @Keywords"