
|
When a Number is Not a Number We store lots of numerical data we never use in calculations. Phone numbers, Social Security numbers, and addresses all contain numbers, but you'd never try to use this type of data in a mathematical expression. Since you don't need these numbers to act like values, you can save memory by storing this type of data as text instead of numbers. A text field can and often does consume less memory than a number field. Just remember that your numeric entries will sort differently as text. For instance, the values 1, 2, and 11 won't sort in numeric order. Instead, these three values will sort as text--1, 11, and 2.
|
||||
| Tips Index | ||||
![]()