[DayOfMonth] VARCHAR(2), -- Field will hold day number of Month [DaySuffix] VARCHAR(4), -- Apply suffix as 1st, 2nd ,3rd etc [DayName] VARCHAR(9), -- Contains name of ...