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!

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

data to be printed on different lines

Status
Not open for further replies.
reportdeveloper

reportdeveloper

Programmer
Nov 4, 2006
1
0
0
US
Hi all,

my table.column2 holds a value 'firstname||lastname' i need firstname to be in first line and lastname in second line,

something like this:

<<firstname>>
<<lastname>>
how can i make this possible

pls help!!
thanks.....
 
Sort by date Sort by votes
What's the rule on where the lastname starts? Is there space between?
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

cdiwindows
  • Locked
  • Question
Select distinct records based on max(date) or NULL date
Replies
0
Views
62
cdiwindows
cdiwindows
csphard
  • Locked
  • Question
sequence in which queries run in the data model
Replies
3
Views
79
csphard
csphard
aalishan
  • Locked
  • Question
Reports 6i shows duplicate lines (rows)
Replies
0
Views
64
aalishan
aalishan
KenCunningham
  • Locked
  • Question
Reports 10G Single Sign On issue
Replies
0
Views
50
KenCunningham
KenCunningham
rrenda
  • Locked
  • Question
SQL Union only returns partial data
Replies
0
Views
48
rrenda
rrenda

Part and Inventory Search

Sponsor

Back
Top