While Umair's Answer might work, it is not guaranteed to get you want you want.
I say might because: why are you using
VARCHAR(50)
to hold dates instead of
DateTime
? In your app all these might be the same, but not when you run your query.
01/01/2011<br />
Jan-01-2011<br />
JAN 01, 2011<br />
2011/01/01<br />
January 01, 2011<br />
01-JAN-11<br />
Since your are using
VARCHAR(50)
they all valid data to store in your field. Is it possible to change your field type to
DateTime
? if so, you will have less headache and maintence.
just my 2
cts