Thanks Rob.

There was a case where early on in my SQL Server life that I wrote a

query like

Update Bla Set Col1 = 'something' From Bla inner join yada...

I disagree Rob,

Nothing personal, but I work with other database systems,

and if I specified the "table your're updating" in the from clause

(without aliasing it that is) it...

Thanks Old Hand, your a godsend.

I actually saw that reference but I have never been able to work out the SQL syntax to all those functions, so you've taught...