I want this to run every day looking for records with today's date in it.

Table xyz

   datefield char(10)

select * from xyz where datefield = ??????

something like informix I could have...