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%'
;
Newer Posts
Older Posts
Home
Subscribe to:
Posts (Atom)