New line in TSQL
newline, sql, sql-server, t-sql
Solution
You should do this in your front end, like on data access layer or may be at presentation layer because your application could be any one a web app or a window app and in both there's different in new line syntax like in web we use `<br/>` tag whereas in window we use `/n`.
Problem
I am getting records from database as comma separated. I am getting contact titles as: ``` greg w.workcerf, ashir ali, asdddfgjk ``` This is comma separated has been defined in SQL function `getCommaListTitle()` What i want is to get these record on new lines as ``` greg w.workcerf, ashir ali, asdddfgjk ``` Any idea about what should i use in sql function instead of `','`