You can do it if you use the Handcent app for texting. It's better than the stock messaging app.
Click on the message thread with this particular person you want to silence. Inside that thread, there will be a settings icon on the top right of the screen that applies to that particular contact. Go to notification settings, then notification sound, then android system. Top one is "silent."