sir

I clearly specified in my earlier mails is

Billingdate is a char type .I want to compare it with two date values

once again writing my query

select *

from table

where Billingdate between date1 And date2

i am not bothering about date1 and date2

the part troubling me is char billingdate

i want tot convert this billing date to date type .How can i use your function in my querry ..plz explain

BillingDate

31/01/2003

31/01/2003

31/01/2003

31/01/2003

31/01/2003

31/01/2003

31/01/2003

31/01/2003