Offending "date" was an '023011'.

Excellent to both of you gentleman. Got it and absolutely working! Thank you so much for all the help. Very much appreciated...!

Very odd. Got an error trying to do the conversion...

Conversion failed when converting date and/or time from character string.

And thats w/ and w/o the PatIndex in the WHERE clause.

So the main problem with this situation is that the data is stored in a DESC column that is a varchar field. And I really only care about the first...

Thanks for the attempt UMG Developer. Still coming back with the same error. Getting some of the records back, but the majority are falling out of the result set because...