Removing Deleted usernames?

[Xphusion]

ok i have a spammer on my forums and i pruned all his posts and deleted his username/Account but the username is still ghosting in the forums on alot of the posts? how can i get these removed?

iv tried doin the maintainence on user posts etctec and nuthin works any ideas?

[Lynne]

When you go to delete the username in your admin panel, you get taken to a second screen that says something like "are you sure you want to delete this user?" and right under there is says something like "if you would like to delete all this users posts first, click here" You need to click to delete the posts on that screen.

I think that since you didn't do it that way, you will have to run a query. I've seen it posted on vb.com, but don't know it offhand.