OraFAQ Forum: SQL & PL/SQL

Home » SQL & PL/SQL » SQL & PL/SQL » Number

Tue, 17 March 2009 03:26

blood98
Messages: 15
Registered: January 2009
Location: Thai

Junior Member

IF I HAVE WORD 'A2E33WWEE123'
I WANT A NUMBER IS THIS WORD
INPUT = A2E33WWEE123
OUTPUT = 233123

Tue, 17 March 2009 03:37

JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...

Senior Member

Look at the Translate function.

And please don't post in upper case.

Tue, 17 March 2009 03:47

joicejohn
Messages: 327
Registered: March 2008
Location: India

Senior Member

@blood98,

What is your Oracle Version? If it is 10g or above you can rely on Regular Expressions also.

SQL> SELECT REGEXP_REPLACE ('A2E33WWEE123', '[A-Z]+', '')
  2    FROM DUAL;

REGEXP
------
233123

Please read and follow the guidelines in OraFAQ Forum Guide before your next post.

Hope the following link helps:
Writing Better SQL Using Regular Expressions

Regards,
Jo

Previous Topic:	ORA-01704: string literal too long in lob columns
Next Topic:	searching

Goto Forum:

]

Current Time: Fri Dec 13 00:47:52 CST 2024