I am assuming the "dev/" that needs to be removed is part of the content of the HTML module. If so, you can use the following script to get rid of it.
Note: Make sure you back up your Database before trying this
SET NOCOUNT ON;
DECLARE
@TextPointer BINARY(16),
@TextIndex INT,
@oldString NVARCHAR(200),
@newString NVARCHAR(200),
@lenOldString INT,
@currentDataID INT;
SET @oldString = N'dev/';
SET @newString = N'';
IF CHARINDEX(@oldString, @newString) <= 0
BEGIN
SET @lenOldString = DATALENGTH(@oldString)/2;
DECLARE irows CURSOR
LOCAL FORWARD_ONLY STATIC READ_ONLY FOR
SELECT ItemID
FROM [dbo].[HTMLText]
WHERE PATINDEX('%'+@oldString+'%', [Content] ) > 0;
OPEN irows;
FETCH NEXT FROM irows INTO @currentDataID;
WHILE (@@FETCH_STATUS = 0)
BEGIN
SELECT
@TextPointer = TEXTPTR([Content] ),
@TextIndex = PATINDEX('%'+@oldString+'%', [Content] )
FROM
[dbo].[HTMLText]
WHERE
ItemID = @currentDataID;
WHILE
(
SELECT
PATINDEX('%'+@oldString+'%', [Content] )
FROM
[dbo].[HTMLText]
WHERE
ItemID = @currentDataID
) > 0
BEGIN
SELECT
@TextIndex = PATINDEX('%'+@oldString+'%', [Content] )-1
FROM
[dbo].[HTMLText]
WHERE
ItemID = @currentDataID;
UPDATETEXT [dbo].[HTMLText].[Content] @TextPointer @TextIndex @lenOldString @newString;
END
FETCH NEXT FROM irows INTO @currentDataID;
END
CLOSE irows;
DEALLOCATE irows;
END
go