Results 1 to 6 of 6
  1. #1
    Join Date
    Jul 2003
    Posts
    10

    Unanswered: Partial Query on a table

    Hello,

    I'm trying to figure how to query a column in my table partially. For example, for a column labeled ID with the following string MM239833, I want to query only those items with "23". so anything w/ MM23 or NN23 or NQ23 it will display it.

    Any help on this would be greatly appreciated!

  2. #2
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    Perhaps: SELECT * FROM MyTable WHERE (ID LIKE '%23%'); --- ADO

    SELECT * FROM MyTable WHERE (ID LIKE '*23*'); -- QBE and stored query
    Back to Access ... ADO is not the way to go for speed ...

  3. #3
    Join Date
    Jul 2003
    Posts
    10
    That didn't seem to work.

    Is there something like ---> Like ((number of space),23) ????

  4. #4
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Check out wildcards in help - especially "?"
    Testimonial:
    pootle flump
    ur codings are working excelent.

  5. #5
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    Quote Originally Posted by rsabalbaro
    That didn't seem to work.

    Is there something like ---> Like ((number of space),23) ????
    What about it didn't work? How did you try to create/run the query?
    Back to Access ... ADO is not the way to go for speed ...

  6. #6
    Join Date
    Jul 2003
    Posts
    10
    I tried the (??text*) and it works. Thanks so much!

Posting Permissions

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