SQL Query
UPDATE ubbt_USERS SET USER_LOGIN_NAME='NewUsername'
WHERE USER_LOGIN_NAME='OldUsername'

the KEY is that the NewUsername be unique..

this is the name that the user logs in as..

the display name is a different beast and can already be changed in the admin cpanel or (if enabled) the user can change it themselves in their profile wink