Need query to strip character from titles

[Gadget_Guy]

Hi,

I am running into an issue where any thread titles that have a "*" in them are causing me to get errors.

I would like a way to go through all thread titles and replace any instance of "*" with either another character or a blank space.

(and by "*", I actually mean the asterisk character)

Ideally, I would like to run a query to first show me them first... then I could delete manually in the forums, if there are not too many.

Or... if there turns out to be a lot, a query to then perform the search and replace automatically.

Thanks,

D.