Hi Jay,

I've been curious and tried it for myself. I've created a user with user name "demo" and have run the following SQL statement: update users set username='temo' where username='demo'. As expected, the user is displayed in the Admin>User Accounts list. So please try again or check your data base table directly whether the change has worked as expected.

Further one I would advise to not use your statement in a production system. Even when username is not primary key, third party modules might rely on that the username will not change during life time.

The next DNN3.3 release will introduce displayname. This new property should be used to display users name, it is calculated as firstname +` ` +lastname by default but changeable inside the user’s profile.