Now I am just putting it all in the original query, but I am getting the same results that I did before; it is still counting the ZIP codes according to the original 9 digit values. I took Mr. Ramirez's advice and put it all into one query, because I am guessing that all SQL functions cannot be used in a query of a query. Here is the query: SELECT ZIP, LEFT(ZIP,5) as shortZIP, COUNT(LEFT(ZIP,5)) AS ZIPCount FROM table
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/SQL/message.cfm/messageid:3087 Subscription: http://www.houseoffusion.com/groups/SQL/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.6
