Thanks for this it is very useful and explains something I came across in someone else's TSQL a few years back.

I assume there is something similar for UPDATED?

I...