OraFAQ Forum: SQL & PL/SQL » REMOVING LAST 4 CHARACTERS FROM STRING( IMPORTANT )

Home » SQL & PL/SQL » SQL & PL/SQL » REMOVING LAST 4 CHARACTERS FROM STRING( IMPORTANT ) (ORACLE 10G, WINDOWS)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

REMOVING LAST 4 CHARACTERS FROM STRING( IMPORTANT ) [message #289003]

Wed, 19 December 2007 04:43

jheds
Messages: 3
Registered: July 2007
Location: pune

Junior Member

HI ,

I WANT TO REMOVE THE LAST 4 CHARACTERS FROM A SRTING.

FOR EXAMPLE STRING = AMITJH
THE OUT PUT I WANT IS : AM.

THE LAST 4 CHARACTERS SHOULD NOT APPEAR.

PLEASE HELP. ITS URGENT.

THANKS.

Report message to a moderator

Re: REMOVING LAST 4 CHARACTERS FROM STRING( IMPORTANT ) [message #289011 is a reply to message #289003]

Wed, 19 December 2007 04:56

Frank
Messages: 7901
Registered: March 2000

Senior Member

- Posting in all Caps is considered shouting and is rude.
- Everyone's post is important
- If it is urgent you should have started earlier

This is basic sql and can be found in the manuals. Go to tahiti.oracle.com and search for substr

Report message to a moderator

Re: REMOVING LAST 4 CHARACTERS FROM STRING( IMPORTANT ) [message #289045 is a reply to message #289003]

Wed, 19 December 2007 06:03

Michel Cadot
Messages: 68770
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

And we already told you this (about urgent and so on) in your 2 first posts.
Aren't you able to follow the rules?

Regards
Michel

Report message to a moderator

Re: REMOVING LAST 4 CHARACTERS FROM STRING( IMPORTANT ) [message #289053 is a reply to message #289045]

Wed, 19 December 2007 06:24

gauravsunil
Messages: 68
Registered: August 2007
Location: bhubaneswar

Member

try it

select substr('sunilgaurav',0,(length('sunilgaurav')-4)) from dual;

Regards
Sunil Gaurav

Report message to a moderator

Previous Topic:	DBMS_Scheduler
Next Topic:	Date Selection

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Sep 04 11:31:31 CDT 2025