Results 1 to 2 of 2

Thread: SQL regexp ?

  1. #1
    Join Date
    Mar 2004
    Posts
    1

    Question Unanswered: SQL regexp ?

    is it posible to recover only the numerical characters of an alphanumeric field?

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1

    Re: SQL regexp ?

    In 10G there will be regular expressions. If you don't have 10G yet then you can do this:

    translate(string, '0' || translate(string, 'X0123456789', 'X'), '0')

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •