The simplest way to delete sms in your iPhone is to do it with an application called SMSD.
Best part is you can do it directly on the iPhone so you won't be needing any mac/computer to do it. Plus, you can delete a SMS in a thread.
You can install it by going to Installer > Utilities.
Enjoy!