Exactly as in MS Access, Interbase/Firebird, and dBase II.