Home » SQL & PL/SQL » SQL & PL/SQL » Ronald McDonald's initials please!
Ronald McDonald's initials please! [message #20251] Thu, 09 May 2002 01:49 Go to next message
Terry
Messages: 13
Registered: September 2000
Junior Member
I have fields 'Forename' and 'Surname' (ie. 'Ronald' 'McDonald') and would like to select just the Forename's initial and Surname (ie. 'R McDonald').

Any quick ideas?

Report message to a moderator

Re: Ronald McDonald's initials please! [message #20254 is a reply to message #20251] Thu, 09 May 2002 03:51 Go to previous message
Suresh Vemulapalli
Messages: 624
Registered: August 2000
Senior Member
select substr(forename,1,1)||' '||surname from table1;

Report message to a moderator

Previous Topic: How to spool data to a fixed fomat file?
Next Topic: nested-group function/single-group function
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Apr 23 10:02:32 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.