How to Update Column in this example in sql?
I've set up a sample here.

Having a look at your data, if you use N:

SELECT     t1.id, t1.Name, t1.C1, t2.N, t2.EditName
FROM       #tbl1 t1
INNER JOIN #tbl2 t2
ON         t1.C1 LIKE '%' + t2.N + '%';


It doesn't return any row. However, if you use EditName:

SELECT     t1.id, t1.Name, t1.C1, t2.N, t2.EditName
FROM       #tbl1 t1
INNER JOIN #tbl2 t2
ON         t1.C1 LIKE '%' + t2.EditName + '%';


You get:

+-------+-------------+-----------------------------------------------+-----------+----------+
|   id  | Name        | C1                                            | N         | EditName |
+-------+-------------+-----------------------------------------------+-----------+----------+
| 29269 | N56 1341se  | N56-11, N56-21, N56-1100, N56-2980, N56-2230, | A N56     | N56      |
| 29270 | N56 1348se  | N56-11, N56-21, N56-1100, N56-2980, N56-2230, | A N56     | N56      |
| 29214 | g6 1325sr   | g6-1, g6-2, g6-1000, g6-1980,       g6-1230,  | H G6-2000 | G6       |
| 29215 | g6 1341se   | g6-1, g6-2, g6-1000, g6-1980,       g6-1230,  | H G6-2000 | G6       |
| 29226 | g6 1342se   | g6-1, g6-2, g6-1000, g6-1980,       g6-1230,  | H G6-2000 | G6       |
| 29237 | g6 1346se   | g6-1, g6-2, g6-1000, g6-1980,       g6-1230,  | H G6-2000 | G6       |
| 29248 | g6 1321sr   | g6-1, g6-2, g6-1000, g6-1980,       g6-1230,  | H G6-2000 | G6       |
| 29259 | g6 1345se   | g6-1, g6-2, g6-1000, g6-1980,       g6-1230,  | H G6-2000 | G6       |
| 29271 | F566 1341se | g6-1, g6-2, g6-1000, g6-1980,       g6-1230,  | H G6-2000 | G6       |
+-------+-------------+-----------------------------------------------+-----------+----------+


And after update it using:

UPDATE     #tbl1
SET        P1 = t2.P2
FROM       #tbl1 t1
INNER JOIN #tbl2 t2
ON         t1.C1 LIKE '%' + t2.EditName + '%';


The final result is:

+-------+-------------+-----------------------------------------------+-------+
| id    | Name        | C1                                            | P1    |
+-------+-------------+-----------------------------------------------+-------+
| 29214 | g6 1325sr   | g6-1, g6-2, g6-1000, g6-1980,       g6-1230,  | 28000 |
| 29215 | g6 1341se   | g6-1, g6-2, g6-1000, g6-1980,       g6-1230,  | 28000 |
| 29226 | g6 1342se   | g6-1, g6-2, g6-1000, g6-1980,       g6-1230,  | 28000 |
| 29237 | g6 1346se   | g6-1, g6-2, g6-1000, g6-1980,       g6-1230,  | 28000 |
| 29248 | g6 1321sr   | g6-1, g6-2, g6-1000, g6-1980,       g6-1230,  | 28000 |
| 29259 | g6 1345se   | g6-1, g6-2, g6-1000, g6-1980,       g6-1230,  | 28000 |
| 29269 | N56 1341se  | N56-11, N56-21, N56-1100, N56-2980, N56-2230, | 32000 |
| 29270 | N56 1348se  | N56-11, N56-21, N56-1100, N56-2980, N56-2230, | 32000 |
| 29271 | F566 1341se | g6-1, g6-2, g6-1000, g6-1980,       g6-1230,  | 28000 |
+-------+-------------+-----------------------------------------------+-------+