Quote:
Originally Posted by jkirchner
Correct  I always try to think what I want to get out of the databases so I can best figure out how to set them up. That rule of make the fields numbers if you ever want to do math with them is a good one. Saves extra effort later. |
Exactly. If you are in a situation where you can't just go back and requery the original data to get it in numerical form, I would avoid continually working with substring functions on every record every time you use it. Do it once to create a new field where everything is numeric. Then work with that field.
