By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,589 Members | 2,255 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,589 IT Pros & Developers. It's quick & easy.

To add line breaks in DB2.

P: 1
I wanted to know how to add line breaks in DB2.
I have got a table which has a field called "address".This field contains data something like this :

Private Company Ltd Italy Tel No:3214124 Fax :21312123

Now while displaying I want to split it and show as below:

Private Company Ltd
Italy
Tel No:3214124
Fax :21312123

So I wanted to know how I can add line breaks in DB so that it can be displayed as shown above.
Sep 25 '07 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.