• Thank you, Sir. Your code works.

    Actually I wanna convey SMS from my database through mobile operator. That's why I want to insert data in my convenient format. If I use char(13) + char(10), it will work too, won't it?

    Another query is when sms will be sent, do the format remain same or will be changed?