As unsatisfactory as it is, I nonetheless thank you for the response.

The reason I thought that it was in fact possible to fill the screen is through websites like IBM's and Microsoft's that have...

I am trying to make a layout for a website with a menu-navigation panel on the left, and the left with a content area. I know how to make blocks 100% height, and I know how to make them scroll, but...

I spent a lot of time looking around, and all I could find was in ASP.NET, and it is a technique called "bubbling", but I need do something similar using WinForms.

I have a Form with a Split...

I couldn't find a userscript for greasemonkey that removed that pesky banner at the top of the page, so I wrote this one, I've made it available here http://userscripts.org/scripts/show/10228

I know, I should just use MySQL, the only thing is that the MySQL team hasn't released the MySQL-Visual Studio integration tools yet.
Until then, Adios

That did it! It was the GROUP BY SUBSTRING() Combination, thank you.
Marked as Solved

No, this didn't work, because when I use the AS keyword in MS SQL, I can't use the alias in a GROUP BY clause, it give me a syntax error.

I just got a SQL 2005 Programming book, but I appreciate...

That worked, except for the Zip column, I am still getting redundant zips. For all of the zips with the same first three letters, I would like to group those together.
I can't find a syntactically...

I need to write a query that pulls out Zip codes by the first three characters, so I started with this:

SELECT SUBSTRING(Zip, 1, 3) FROM AvailHomeZips AS tZip

But I would also like to query...