could you use:
Select Contact.*
where between(contact.dob, date(), date())
>Hi Folks -
>
>If I have a table which contains a contact name and date field, dob. What command would I use to filter the data down only to show the contacts with a birthday (based upon the dos clock date) of today ?
>
>Would I need to convert the month and day to character? If so is that the only way?
>
>Thanks,
>
>Larry
Roi
'MCP' Visual FoxPro
In Rome, there was a poem.
About a dog, who found two bone.
He lick the one, he lick the other.
He went pyscho, he drop dead!