I've never used FoxPro before, but have to now for a uni assignment. I need to create some tables, using SQL statements, that contain (among other things) fields such as:-
HorseDOB (DD/MM/YYYY)
Odds (4-1, 5-4 etc)
SexOfHorse (M/F)
Result (either 1,2,3,4,U or N)
TimeofRace (HH:MM)
and...