yeah my Fromdate is a varchar as i told you and now i tried doing cast(fromdate as datetime) i get hte result set ok but with an error message

Msg 241, Level 16, State 1, Line 1

Syntax error converting datetime from character string.