Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2004
    Posts
    26

    Unanswered: function to filter out special characters and alphabets?

    hi, is there a function in SQL that filters out special characters?

    i want to select records that are like this, these are all in varchar:

    .808
    #8 2/F
    !308
    G14A


    and ignore records that have less than 2 characters, such as:

    34
    1
    A



  2. #2
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    select my_field
    from my_table
    where length(my_field) > 2;
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

  3. #3
    Join Date
    Jul 2004
    Posts
    30
    try this:
    select field
    from table
    where urfield like '%!308%' or like 'G14A ... so on;

Posting Permissions

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