I'm not an iPhone user, but help support them at work.
We have a user who has a large amount of SMS messages for having the same iPhone for quite a few years. He's trying to delete old SMS messages.
On my Android (Galaxy S3), I'm able to set a Text message limit: 200 messages per conversation, so only the most recent 200 messages are kept for each conversation.
Is there something similar for iOS?