I need to write a SQL update query. I want to update where workorder=12300000
column1.TrimStart(B7CL).Addto(column2). But how can I do that in SQL Server 2005?
Convert this table:
workorder |column1 | column2
12300000 |B7CL-B32-41-00-5A | NULL
12400000 |B7CL-B33-42-00-5A | NULL
12300000 |B7CL-B34-44-03-5A | NULL
12600000 |B7CL-B35-45-01-5A | NULL
12300000 |B7CL-B36-45-01-5A | B36-45-01-5A
To this table:
workorder |column1 | column2
12300000 |B7CL-B32-41-00-5A | B32-41-00-5A
12400000 |B7CL-B33-42-00-5A | B33-42-00-5A
12300000 |B7CL-B34-44-03-5A | B34-44-03-5A
12600000 |B7CL-B35-45-01-5A | B35-45-01-5A
12300000 |B7CL-B36-45-01-5A | B36-45-01-5A
Update Table
Set Column2 = Replace(Column1, 'B7CL-','')
Where Column2 Is Null
AND workorder=12300000