Results 1 to 8 of 8

Thread: Oracle wildcard

  1. Sep 10th, 2001, 06:01 AM #1
    Gaffer
    Gaffer is offline

    Thread Starter
    Fanatic Member Gaffer's Avatar
    Join Date
    Nov 2000
    Location
    London
    Posts
    828

    Oracle wildcard

    I have a field in an oracle db of datatype VARCHAR2(24) (alphanumeric)

    I amy trying to extract records where the above field is a 6 digit numeric

    e.g.

    168497 I need this
    568478 I need this
    SWTA-HGT Don't need this
    12476 Don't need this

    In MS Access (gawdblessit), you can use the '#' wildcard to identify numerics. Any such wildcard in Oracle?

    Cheers
    Reply With Quote Reply With Quote
  2. Sep 10th, 2001, 06:06 AM #2
    Gaffer
    Gaffer is offline

    Thread Starter
    Fanatic Member Gaffer's Avatar
    Join Date
    Nov 2000
    Location
    London
    Posts
    828
    s'OK, got my solution but not ideal . Any ideas on numeric wildcards still appreciated...
    Reply With Quote Reply With Quote
  3. Sep 10th, 2001, 06:07 AM #3
    paulw
    paulw is offline
    Fanatic Member
    Join Date
    Oct 2000
    Location
    London
    Posts
    1,008
    probably.

    Is it my turn to pay for the Ramen?

    How did the wedding go?

    When do you want to eat?

    Cheers,

    P.
    Not nearly so tired now...

    Haven't been around much so be gentle...
    Reply With Quote Reply With Quote
  4. Sep 10th, 2001, 06:09 AM #4
    Gaffer
    Gaffer is offline

    Thread Starter
    Fanatic Member Gaffer's Avatar
    Join Date
    Nov 2000
    Location
    London
    Posts
    828
    Probably????? You deserve to buy me Ramen after that Paul!!! I'm ready today if you like...
    Reply With Quote Reply With Quote
  6. Sep 10th, 2001, 06:34 AM #5
    rudgej
    rudgej is offline
    Hyperactive Member
    Join Date
    Jan 2000
    Location
    Edinburgh, Scotland
    Posts
    272
    Have you tried the underscore character _ ?
    Reply With Quote Reply With Quote
  7. Sep 10th, 2001, 07:10 AM #6
    Hack
    Hack is offline
    I'm about to be a PowerPoster! Hack's Avatar
    Join Date
    Aug 2001
    Location
    Searching for mendhak
    Posts
    58,333
    The wildcard character in Oracle is the % sign.
    Reply With Quote Reply With Quote
  8. Sep 10th, 2001, 07:17 AM #7
    rudgej
    rudgej is offline
    Hyperactive Member
    Join Date
    Jan 2000
    Location
    Edinburgh, Scotland
    Posts
    272
    The % character is for any number of characters though.
    Reply With Quote Reply With Quote
  9. Sep 10th, 2001, 07:24 AM #8
    Hack
    Hack is offline
    I'm about to be a PowerPoster! Hack's Avatar
    Join Date
    Aug 2001
    Location
    Searching for mendhak
    Posts
    58,333
    You are correct about that.

    You are looking for a way to specifically identify field entries that are 6 numeric characters ONLY? Am I reading your question correctly?
    Reply With Quote Reply With Quote
« Previous Thread | Next 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
  •  

Forum Rules


Click Here to Expand Forum to Full Width