I hope I am not posting this twice ,since my answer seems to have disappeared but

Try this script to generate your dates

Generates a rowset with a datetime values for every...

Thank you both for your solutions.I was unable to make any futher progress on my own.

Both methods worked to narrow my orginal result set from 3733 rows with duplicates/outdated information...

Steve

Thank you for your reply.I seem to remember using some combination of CHARINDEX/PATINDEX and Len

to solve a problem involving breaking up a single field into two fields in the...