Use CardioLog GO -- Edit date range YYYY-MM-DD DECLARE @startTime datetime = '2019-01-01' DECLARE @endTime datetime = '2019-06-01' update tab_event_log set searchurl = replace(searchurl,'+',' '), url = replace(url,'+',' ') where Created ='1900-01-01 00:00:00.000' and timestamp >= @startTime and timestamp < @endTime and url like '%+%' update tab_event_log set searchurl = replace(searchurl,'%20',' '), url = replace(url,'%20',' ') where Created ='1900-01-01 00:00:00.000' and timestamp >= @startTime and timestamp < @endTime and url like '%%20%' update tab_event_log set searchurl = replace(searchurl,'%2D','-'), url = replace(url,'%2D','-') where Created ='1900-01-01 00:00:00.000' and timestamp >= @startTime and timestamp < @endTime and url like '%%2D%' update tab_event_log set userName = case when charindex('|', userName) > 0 then ltrim(rtrim(right(userName, charindex('|', reverse(userName)) - 1))) else ltrim(rtrim(userName)) end where timestamp >= @startTime and timestamp < @endTime EXECUTE [dbo].[stp_eventlog_fix_lost_events] @startTime ,@endTime GO