Stipping all alpha characters from a string

From: Alyx (alyxk_at_labx.com)
Date: 04/27/04

  • Next message: Vishal Parkar: "Re: Stipping all alpha characters from a string" 
    Date: 27 Apr 2004 13:11:56 -0700

    I need to strip all characters that are not a number from a string
    variable in a sql procedure. There is not clear pattern to the
    character the user can input.

    Example input for the phone field
    1. call me
    2. 1 (555) 555-8888
    3. please email
    4. +049.890.9876
    5. 0x0x0x
    6. Work: (444) 123-4567

    I need to strip the characters down to only a number so I can evalute
    if a correct entry was made.

    After stripping and checking above example numbers 2,4, and 6 would be
    the only examples that would come back valid.

    Any help would be appreciated.

    Thanks,

    Alyx

  • Next message: Vishal Parkar: "Re: Stipping all alpha characters from a string"

    Relevant Pages