Results 1 to 2 of 2
  1. #1
    Join Date
    May 2002
    Location
    Australia
    Posts
    26

    Unanswered: i'm learning contraints

    Hi There

    I have two fields one of either can be null and one must not be null.

    I was trying something like this
    (field1 & field2 is NOT NULL)

    It doesn't work.

    Thanks in advance!

    Rim

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    try: NOT (field1 is null and field2 is null)

    or: (field1 is not null OR field2 is not null)

    rudy

Posting Permissions

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