Yes... do the right thing and convert the column to a proper DATETIME column... opens things up for date calculations and a whole world of canned formats.

--Jeff Moden

Yes, I was looking for it to know that it is something other than DATETIME that you have at present. I would always suggest to move it to DATETIME from varchar, that makes you job easier than doing string manipulation considering all possibilities of values as you said, which makes your life tough.

cheers.

_________________________
- Vijay G
Strive for Perfection