CYNTHIA SPELL
CSPELL at jhuccp.org
Mon Oct 13 06:44:46 CDT 2003
Thanks, Gustav! >>> gustav at cactus.dk 10/13/03 07:36AM >>> Hi CYNTHIA > I inherited a budget number database with the primary key being a 7-digit number. The data type for the field is currently number (long integer). Since the field requires no calculation, just > some sorting, I'm considering changing the data type to text. The budget number table links to quite a few other databases, so I'll have to change the field in other places. Is there a benefit to > or problem with using one or the other data type? I remember an instructor once saying that if there's a choice between using a text or number type, use number since numbers sort faster than text, > but I'm not so sure he knew what he was talking about. He did. With no good reason for the change, I would spend my time on more interesting tasks! /gustav _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com