Results 1 to 5 of 5
  1. #1
    Join Date
    Jan 2004
    Location
    South Africa
    Posts
    178

    Question Unanswered: opposite of like (SQL)

    is there such a function as not(like "100*") in SQL?

    thanks in Advance
    ActionAnt

  2. #2
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    Quote Originally Posted by actionant
    is there such a function as not(like "100*") in SQL?

    thanks in Advance
    ActionAnt
    Yes. It's NOT LIKE( ...

  3. #3
    Join Date
    Oct 2003
    Posts
    13
    Remember SQL doesn't use "*" as its wildcard. It uses '%'.

  4. #4
    Join Date
    Dec 2002
    Location
    Préverenges, Switzerland
    Posts
    3,740
    * -or- % depends on your version of Access.

    (...which should encourage everyone to give details of their setup in their signature, but evidently it doesn't).

    izy
    currently using SS 2008R2

  5. #5
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    Quote Originally Posted by MyerK
    Remember SQL doesn't use "*" as its wildcard. It uses '%'.
    SQL is merely a standard adhered to by many databases. The specific syntax used is indicitive of the specific platform only.


    Check out my new sig Izy!! Just for you!!






    *Yes, I am a bit cheeky on Monday's, can't help it.
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

Posting Permissions

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