Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to Add a New Line in a Varchar in a Stored Procedure (SPL)

Status
Not open for further replies.

evgeniosc

IS-IT--Management
Oct 5, 2002
75
CY
How can I add a new line character in a varchar variable in a stored procedure?

e.g

Define returnValue varchar(50);
Define newLine char(2);

Let newLine = ???
Let returnValue = 'Line1' || newLine || 'Line2';
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top