How to trigger a Line break on a SMS

Question

I'm gonna write SMS service that sends SMS's automatically.In that case i am going to create my SMS content by SQL.

So is it possible to add a line break by using some special command or a character?

Answer 1

i have concatenate CHAR(10) to my SQL message content an it worked !!!