Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2013
    Posts
    10

    Unanswered: MS Access 2007 - SQL - Query - number matching

    Hi there, Pretty new to the database designing. However learning quickly, Gotta love Google.

    I'm trying to get the query to search for a number with a record.

    I've been using the Like '*1*' which works fine, however when i'm saying to Not Like number 13 it won't include the number 1.

    So it there a way of getting it to like just the character "1" rather than "1" and 3 .

    I'm guessing that the '*1*' is slightly wrong, a pointer in the right direction would be amazing.

    thank you

  2. #2
    Join Date
    Jul 2013
    Posts
    10
    Just worked it out. Quite easy really,

    Like '1'

Posting Permissions

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