Wednesday 21 March 2012

Replace in MSSQL

Replace in MSSQL

use Satellites
Declare @ss as nvarchar(400)
set @ss ='.png'
Update dbo.Frequencies_Owners
Set logoLink = REPLACE(cast(logoLink as nvarchar(max)), @ss, '')

No comments:

Post a Comment