Check out Engage: F3 available for free from www.engagesoftware.com for doing find/replace in HTML modules.

Aliases are defined on the Admin/Site Settings page, but you need to be logged in as a Super User (host) to access the settings for portal alias.

---

Chris Hammond
Former DNN Corp Employee, MVP, Core Team Member, Trustee
Christoc.com Software Solutions DotNetNuke Module Development, Upgrades and consulting.
dnnCHAT.com a chat room for DotNetNuke discussions

Alright... I have come up with a script that works like a charm and takes way less time and resources if you have access to the SQL Management Studio... I do not offer any guarantee here, but this from my experience works better than the few other solutions I found online...

You may have to alter this slightly for your use, but this did the trick for me.

/*--------------------------*/
-- Find and Replace

UPDATE dbo.DNN_HtmlText
SET [Content] = CAST(REPLACE(CAST([Content] as NVarchar(MAX)),'stringtobereplaced','newstringtobeinserted') AS NText)
where [Content] like '%stringtobereplaced%'

-- Verify New Row Counts

select count(*) from dbo.DNN_HtmlText where [Content] like '%stringtobereplaced%' --should be 0

select count(*) from dbo.DNN_HtmlText where [Content] like '%newstringtobeinserted%' --should be the number of replaced items

--If rowcount is correct, commit transaction. If rowcount is off, rollback transaction

--*******************
--COMMIT TRANSACTION
--ROLLBACK TRANSACTION
--*******************
/*--------------------------*/ 

Just wanted to share this.