#6: Numeric vs. Character Datatype

• Need: numeric data with leading zeroes Character Numeric (INT or DEC)

• Automatic edit checking for numeric data.

• Potential for more efficient access because filter factors are more accurate.

• Best choice for domain.

• If input properly, leading zeroes always show.

• Requires rigorous edit checking for data entry.

• Not the “best” choice for the value domain.

Previous slide

Next slide

Back to first slide

View graphic version