That's it

Thanks

Hi,

I am sorry for the unclearness of this matter, but I believe you have summed it up quite nicely.

I am having trouble with this subquery part:

Join

(select ResJoinID, max(ChangeDate)...

Thanks guys this worked nice.

Regards

Douwe Bijkersma

I inserted the 19 and 20 prefixes but now I still got the problem.. By using the top I figured that there was a currupt value that had the date...

Sure I'll try that, but how would I make an update checking the first few chars and so determining if it should be 20 or 19 and then putting it...