Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Wildcard in an IN?

Discussion in 'Information Technology' started by Merlin, Jul 28, 2006.

Tags:
  1. Merlin

    Merlin
    Expand Collapse
    Guest

    I have a series of part numbers, for example 9013XXyyZZ
    I was trying to use sort of a backwards usage of IN
    like this part_number IN('9013*', '*ZZ')

    Is there anyway to do this? Or am I stuck with a series of LIKE's and
    OR's
     
  2. Douglas J Steele

    Douglas J Steele
    Expand Collapse
    Guest

    You're stuck with a series of LIKE's and OR's.

    --
    Doug Steele, Microsoft Access MVP
    http://I.Am/DougSteele
    (no e-mails, please!)


    "Merlin" <Robert.Cordani@us.schneider-electric.com> wrote in message
    news:1152893907.100999.33330@i42g2000cwa.googlegroups.com...
    > I have a series of part numbers, for example 9013XXyyZZ
    > I was trying to use sort of a backwards usage of IN
    > like this part_number IN('9013*', '*ZZ')
    >
    > Is there anyway to do this? Or am I stuck with a series of LIKE's and
    > OR's
    >
     

Share This Page