Yeah, don't store dates as varchars, store them as datetime data types and then the comparisons will be date-based, not string based.

I strongly recommend fixing the data types. Any other form of workaround will be slow, painful or both.