On Tue, April 19, 2005 11:55 am, Hank said: > Except that the zip code field is not (and should not be) numeric, so > the qualification test fails.
*IF* your zip codes are all US zip 5-digit, and *IF* performance is really crucial, and *IF* you are 100% certain you'll never need non-US nor zip+4, and *IF* MySQL int optimization proved *much* faster... I could see a valid argument for making the zip field int. That's a hell of a lot of IFs, and I'm willing to bet that it will bite you in the butt one day, because you were *wrong* about never needing internation or zip+4, but there it is. -- Like Music? http://l-i-e.com/artists.htm -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]