Hi
I have an SQL table that contains a field "Date" of type char,I've heard that there is a function that calculates the number of Days after the year 1900,
For example if I have the date 25/05/2006 and 06/06/2006 because Date is of char type,so it considered 25/05/2006 greater then 06/06/2006 what i want is to find the total number of days between 1900 and 25/05/2006 and the total number of days between 1900 and 06/06/2006 that way I can query my table correctly?

Can anyone tell me what's this function?

Thanks