Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2003
    Location
    Brisbane, Australia
    Posts
    30

    Unanswered: quick sql question...

    Hi all,

    Just trying to retreive records from a table where a field does not equal something but it is not giving me anything!

    Here is the syntax i have at the moment

    Select *
    From tablename
    where fieldname != 'something'

    Any ideas on why this isn't working?

  2. #2
    Join Date
    Oct 2003
    Location
    Canada
    Posts
    574
    My best guess would be that Fieldname is sometimes null which will give a 'wierd' response.

  3. #3
    Join Date
    Dec 2002
    Location
    Préverenges, Switzerland
    Posts
    3,740
    != is very nice but it's not access. try <>

    izy
    currently using SS 2008R2

Posting Permissions

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