I rarely use SQL and have a unique issue I need to solve. I have a table called "j17\_users" with various columns, two of which are "name" and "username". There are hundreds of rows of data.

I need to change the contents of "name" to be the same as "username"

For example, before:

```
name: Jon Smith
username: sql_nub

```

after:

```
name: Sql_nub
username: sql_nub

```

OK, so some of you may have noticed that the first letter has changed to uppercase in the above example. Bonus points if I could get that to happen in the script as well. If it's not possible than so be it..