Jeff -

How then would one be able to sort chronologically on this field? Is there a way to keep the format while changing the data type to a numeric...

I cannot take all the credit as I read your article on Forum etiquette before posting. So thanks to you as well.

Thanks this works perfectly. I appreciate your help!

The client needs a dump of their data and the way how the tables were designed does not allow for a simple query. The result from the query displays directly...