Hi Guys

I've got a table with a varchar column that has been used to hold dates. Not great, I know, but that's the siutation as it is. Worse, it often contains other 'flavour' text like "entered on" or similar. I've now got a requirement to report out the dates from this column. And worse still, the daytes are in different formats, ie with slashes(01/01/12), dots(01.01.12), straight numeric (010112), with and without centuries... you name it, it's in there. About the only the oonly think I can reasonably rely on is that they'll follow the DMY ordering.

I'm trying to think if there's a way I can parse those dates out. I can probably write an algorithm using replace and charindex etc but the number of permutations that could have been entered is huge. Any suggestions or am I just stuffed?