> OK. The same interface is in my digital cable TV box. I can browse the list of shows, but cannot search for all shows with "Star" in the name. Scrolling through all the S programs is time-consuming and shows that don't even start with S cannot be searched - making it a lame design, not matter how common.
>
>The windows xp add/remove programs also presents a list - no search tool, no filter ability - we are forced to sit their while it takes seemingly forever to appear. Lame.
>
>Ok, here's the only way I know how to respond. (I'm trying to limit "self-promotion", but I"m gonna reference one of my CoDe articles)
>
>My personal email is an AT&T email. When I'm on the road and want to check it, the browser interface isn't very good. If I have a long list of emails and I want to go to the person with a last name of 'S'....I need to go to the end, and click BACK....BACK....BACK.... OK, THAT is LAME!!!! ;)
>
>But that's really independant of whether sprocs were used or not. It's just not a powerful design.
>
>So I wrote an article in Code... http://www.code-magazine.com/Article.aspx?quickid=0703041
>
>It shows how to implement custom paging, quick lookup capabilities, and variable searches, all with a stored proc. I agree, one key to a good UI is helping people "get to" their data without a long sequence of keystrokes.

Thanks for the article!

I'm glad we agree on the UI, sorta. :) I wrote an article advising people not to abandon dynamic sql due to mistaken beliefs about SQL injection and stored procedure performance: http://msvfp.advisorguide.com/doc/18675