I've got a search page where the user searches events by date, keyword 
(listbox) and text phrase (text box).

I'm currently building a sql string depending on user input and searching 
the list of events stored in SQL Server.

Question:  Would I get better performance by just searching on the dates, 
filling a dataview object with the records then performing a
objDataView.RowFilter =3D "WHERE colText LIKE '%" & txtBox.Text "%'"
where necessary?

Thanks

Mitch