I have table like this

```
Column1
-------------------------------------------------------
nn=APPLE IPod 44454,o=0006,o=TOP8,nn=USA,nn=TOP8+
nn=SAMSUNG G5 487894,o=04786,o=T418,nn=JPN,nn=TO478+

```

And I need update that table and get result like this

```
Column1                                                 Column2
---------------------------------------------------------------
nn=APPLE IPod 44454,o=0006,o=TOP8,nn=USA,nn=TOP8+        44454
nn=SAMSUNG G5 487894,o=04786,o=T418,nn=JPN,nn=TO478+    487894

```

My idea is but I can not fit with first character:

```
update tablename 
set [column2] = SUBSTRING(column1, 1, CHARINDEX(' ', column1) - 1 (column1, CHARINDEX(' ', column1) + 1, LEN(column1))

```