Line line is a select statement.

vanikanc

hi, I have the following sql. select '00' + 'TESTIN' + '634' + SPACE(56) + '000001' + CHAR(13) + char(10) + '1' I need the 1 on the next line, as I have specified CHAR(13) + char(10). But it does show that way, it still appears on the same line. Any help is appreciated.

jschell

So where exactly are you running this? In other words where exactly do you expect this "next line" to show up?

vanikanc

Thank you. Sql server 2005

Niju1

Hi char(10) and char(13) will work only when results to text.. it won't work if the results are displayed in grid

Ingo

vanikanc wrote:

select
'00' + 'TESTIN' + '634' + SPACE(56) + '000001' + CHAR(13) + char(10) +
'1'

In my eyes this is abuse of SQL. Such things should be done with the software not in a SQL-Script. If you really need to, place to SELECT Statements:

SELECT '00' + 'TESTIN' + '634' + SPACE(56) + '000001';
SELECT 1;

------------------------------ Author of Primary ROleplaying SysTem How do I take my coffee? Black as midnight on a moonless night. War doesn't determine who's right. War determines who's left.

jschell

vanikanc wrote:

Sql server 2005

SQL Server is a database server. The end of line character means nothing in the database. There is no way to 'display' it. So that is not how you are using it. Best I can suppose is that you are running the Microsoft SQL Server Management Studio and it show 'rows' and columns and your value is thus in a row and in a column and it will not display it any other way.