The only issue with that would be sorting them numerically versus alphabetically
0 1 10 2 20 3 30 Would be what youd get with these numbers alphabetically instead of numerically... 0 1 2 3 10 20 30 What if you just make them decimals? 001 = .001 It would sort correctly numerically and you'd just take the . out for display. It's a hack but it depends on whether or not sorting them numerically is important at all in your app. ..:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -----Original Message----- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 03, 2006 11:10 AM To: CF-Talk Subject: RE: phone numbers in database > My phone fields are broken up into 3 parts, area code, prefix > and phone number. Each of those sections are a field in the > DB, so 3 fields for a phone number. The fields are integer type. Phone number fields should be character data, not numeric. You should only use numeric fields for values which actually are used and treated as numbers - for example, things you add and subtract, etc. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:228227 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
