hi mccork,

great My problem is solved with out using a function .I have provided my final query below ..

will you have any solution to convert string in format 29.02.2003...

i have modified your function and it is working perfectly fine

now i m using a query like this

select *

from table

where dbo.condate(billingdate) between date1 and date2 ...

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 ...

crispin

thanks again ,before looking for help i have tried this

cast(billingdate as datetime) but it is giving me a error

Server: Msg 8115, Level 16, State 2, Line 1

Arithmetic...

crispin

thanks for immediate response but my problem is not solved .

see i have copied my column hear

i need to compare each date in this column...