how to display the initials ? [message #373518] |
Fri, 20 April 2001 09:13 |
nelson
Messages: 30 Registered: February 2000
|
Member |
|
|
hi all
i need to know the query for the following.
if my table A have column name with the folllowing details
name
J. Soundar Prakash
S. J.Karthik
J.A.John Nelson
i want a query
to display like
JSP
SJK
JAJN
...
help me
nelson
|
|
|
Re: how to display the initials ? [message #373519 is a reply to message #373518] |
Fri, 20 April 2001 11:00 |
Bala
Messages: 205 Registered: November 1999
|
Senior Member |
|
|
Hi,
select replace(replace(replace(translate('J. Soundar Prakash', 'abcdefghijklmnopqrstuvwxyz',
'xxxxxxxxxxxxxxxxxxxxxxxxxx'), 'x', ''), '.', '' ), ' ' , '') from dual;
REP
---
JSP
Bala.
|
|
|