中等ICT-DBAS-014
House points are stored as text. A sort puts "100" before "20". Why can that happen?
A. Text is ordered character by character, so "100" can come before "20".✓ 答案
B. A text field cannot be shown on a form.
C. Every numeric field sorts 100 before 20 as well.
D. A primary key must be stored as text, so the order is required.
解說
The first character "1" comes before "2". Store quantities as numbers if you need numeric order.