I needed to find and replace text in a text field in sql2000… here’s how I got it right: declare @StringToReplace varchar(1000) SET @StringToReplace = ‘baad string’ declare @NewString varchar(1000) SET @NewString = ‘new improved string’ declare @start int declare @end int SELECT @end = len(@StringToReplace)-2 declare @currentrecord int declare @ptrval BINARY(16) declare @TotalOldTextInstancesStillToBeFixed int [...]