SQL query within a row for values

I'm sort of new to SQL and I was wondering If it was possible to Query through a Certain Row for a Value because I have Columns that are set up to be the names of medication, and all values within the table are Time Periods. So I want to compare the current time to all of the time periods within that row.

_________________Col 1______________Col 2_______________Col 3______________________ rowid 1 |______ 12-22-2014 5:00 _____ 12-03-2014 2:00 ____12-09-2014 12:00_____________