Filtering Data from sql server
I have a web page that returns over 36000 items from sql server and I need ideas to filter the data. So far my ideas are paging through letters and a text search box which uses the following sql - 

		select			O_ObjectID, 
					rtrim(O_Name) as O_Name
		from			A_Object
		where			O_Name like @NamePrefix + '%' OR O_Name like '% ' + @NamePrefix + '%'
		order by 		O_Name

So any thoughts in which I can filter data?
Filtering Data from sql server
===

I have a web page that returns over 36000 items from sql server and I need ideas to filter the data. So far my ideas are paging through letters and a text search box which uses the following sql - 

		select			O_ObjectID, 
					rtrim(O_Name) as O_Name
		from			A_Object
		where			O_Name like @NamePrefix + '%' OR O_Name like '% ' + @NamePrefix + '%'
		order by 		O_Name

So any thoughts in which I can filter data?