Using the isdate to a temp table seemed to

Get all the correct rows needed for date compare.

Thank to everyone for the helpful information, great site with

Very knowledgeable people.

All the date formats in the varchar column are the same

Format '04/05/2010' mm/dd/yyyy

I need to compare of greater then the other colum of those dates against another column that has...

The isdate would return 0 and 1 correct?

I need to be able to compare the two tables to verify date value ranges are <> one or the other.