I want to perform an SQL Query that matches a field in my dbase with the current day. <BR><BR>Example.. day (the field) = TODAY (Monday, Tuesday, Wednesday...) Can anyone tell me the correct SQL statement to perform this task? Here is the one I've been trying.<BR><BR>SELECT * FROM OnAir WHERE day = day(now)<BR><BR>It doesn't give me an error, but it also returns no records. It should return the record that under the field day is SUNDAY. <BR><BR>Thanks for any help. Hope this makes sense.