Rahul Krishnan R
Thursday, November 25, 2010
Replace Command in Update Statement ( Sql Server 2005)
UPDATE
dbo.authors
SET
city = replace(city,
'Salt'
,
'Olympic'
)
WHERE
city
LIKE
'Salt%'
;
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment