Need query to strip character from titles

[Gadget_Guy]

This worked perfectly... and helped me find the REAL cause of the issue.

I see that threads with "*" in them are fine and only a few are what is throwing the error.

It looks like deleted users who I think weren't deleted properly and turned into "Guests" is the real issue.

The "Chris G" posting you see is not in the system any more... it was deleted as part of a cleanup of users who haven't visited the forums in a long time.

See the attached screen shot.

All the threads that throw the error have users like the one here.

Now... how can I properly clean up these users..... or... find threads with users like this and clean those out?

D.