Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2012
    Posts
    1

    Thumbs up Unanswered: How to Remove alpha from the alphanumeric and get the Numeric value only

    Hai All,

    How to Remove alpha from the alphanumeric and get the Numeric value only.

    Example :

    Column : Reg_No : A07ca103 (varchar)

    I want the output as 07103 ( Int )

    or simply 103 is also more than enough.

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Use the TRANSLATE() function to translate all alphabetic characters to empty strings, which will leave only digits.
    ---
    "It does not work" is not a valid problem statement.

Tags for this Thread

Posting Permissions

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