OraFAQ Forum: SQL & PL/SQL » extract some letters from a string

Home » SQL & PL/SQL » SQL & PL/SQL » extract some letters from a string

Mon, 04 March 2002 05:46

Jess
Messages: 3
Registered: March 2002

Junior Member

Does somebody can tell me how to extract the two first letter from a string?
Ex.: My name is Lemieux,
I want the system extract the letters 'Le'

Mon, 04 March 2002 05:59

pratap kumar tripathy
Messages: 660
Registered: January 2002

Senior Member

substr('Lemieux',1,2)

Mon, 04 March 2002 10:38

alina
Messages: 1
Registered: March 2002

Junior Member

string=My name is Lemieux.
substr(string,12,2) = Le

Mon, 04 March 2002 13:35

Lance Pris
Messages: 40
Registered: January 2002

Member

If I wanted to strip the last x number of letters from a sting how would I do that if I did not know the exact length?

thanks
Lance

Previous Topic:	Re: Cross Tab Report
Next Topic:	create new record based on old...

Goto Forum:

]

Current Time: Tue Apr 23 18:11:37 CDT 2024