SQL Server Technet
(Move to ...)
Home
▼
Friday, 27 June 2014
UPDATE and REPLACE TSQL
Find the example TSQL to use UPDATE statement with REPLACE function,
UPDATE
[AdventureWorks2008R2]
.
[Person]
.
[Person]
SET
FirstName
=
REPLACE
(
FirstName
,
'sam'
,
'jim'
)
Where
FirstName
=
'sam'
No comments:
Post a Comment
‹
›
Home
View web version
No comments:
Post a Comment