New Line Character

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » New Line Character

New Line Character

Rate Topic

Display Mode

Topic Options

Author

Message

Minnu

Posted Monday, September 17, 2012 5:02 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Today @ 3:12 AM
Points: 123, Visits: 367

Hi,

Am using below query to display veh_name, expiration_date,

for new line character, here am using "+CHAR(10)"

what is the new line character, to display the below query.

CREATE VIEW [dbo].[Veh_Market]
AS
SELECT id,
CASE WHEN Veh_Name IS NULL or Veh_Name = '' THEN ''
ELSE CASE WHEN expiration_date IS null then
' Vehicle Name: ' + Veh_Name +CHAR(10)
ELSE ' Vehicle Name: ' +Veh_Name + ' (Expires ' + rtrim(convert(varchar, expiration_date,107)) + ')' +CHAR(10)
END
END
AS summary FROM veh

plz help................

Post #1360105

laurie-789651

Posted Monday, September 17, 2012 5:34 AM

SSC Veteran

Group: General Forum Members
Last Login: Today @ 3:37 AM
Points: 275, Visits: 790

What are you trying to do exactly?

Post #1360119

Lokesh Vij

Posted Monday, September 17, 2012 6:05 AM

Ten Centuries

Group: General Forum Members
Last Login: Yesterday @ 8:24 AM
Points: 1,176, Visits: 1,253

Skanda (9/17/2012)

what is the new line character, to display the below query.

Please be clear and specific. If you are new to this forum, its worth looking at best practices to post your queries (check my signature for the link)

~ Lokesh Vij

Guidelines for quicker answers on T-SQL question
Guidelines for answers on Performance questions

Link to my Blog Post --> www.SQLPathy.com

Follow me @Twitter

Post #1360135

2ndHelping

Posted Thursday, September 20, 2012 11:55 AM

Grasshopper

Group: General Forum Members
Last Login: Friday, September 28, 2012 6:58 AM
Points: 11, Visits: 51

actually, char(10) IS the newline character. Maybe you're looking for carriage return? If so, that's char(13)

Post #1362206

« Prev Topic | Next Topic »

Permissions