>So I believe it is a personal preference for syntax style based on each programmer's preference or the standards set forth by the company owning the development. In either case I believe it is wise to have programming standards and then to adhere to them.
Hell, I use them both just to be triple sure:
select mytable
replace mytable.myfield with x in mytable
Me for the win!!!!
Brandon Harker
Sebae Data Solutions