I am ever so grateful. This willl certainly leverage my SQL skill

Thanks guys

Fantastic. Really grateful.

Will test it out shortly and let you know

This is remarkable. Thank you.

It worked and I will have to study whats happening to apply it.

The table I am working on has thousands of rows and many more columns....

Really appreciate you helping:

The same CCAC value will not be entered more than once for each group of rows. I also can change the data type to integer.

However, remember I...

How do you do that? Can you show me?

Really grateful. Many thanks