Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2003

    Question Unanswered: query to return only non null fields

    Is it possible to write a query to return only the fields in a record which are not null. I have a big table of customers which contains fields for items ordered. Not every customer orders every item and I want to do an invoice. I know this isnt a normalised database but the customer only ever buys once.
    Any help here would be great


  2. #2
    Join Date
    Oct 2002
    Leicester - UK
    where [field] is not null
    Definition of a Beginner, Someone who doesn't know the rules.

    Definition of an Expert, Someone who knows when to ignore the rules.

Posting Permissions

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