shohelr2003 (1/15/2013)
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?
can you post the table defintion from which above data will be picked uo as SMS content.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)