Urgent!! SQL question

Results 1 to 3 of 3

Thread: Urgent!! SQL question

  1. #1
    Please Help Guest

    Default Urgent!! SQL question

    I need to edit my SQL statement to select records that are both null and do not contain a value (since null is a value itself) I know that I can&#039;t use "" to represent blank in SQL, so how would I say<BR>"SELECT * FROM table WHERE Field1 IS NOT NULL and Field1 (is blank!!!!)??<BR>Thanks so much!

  2. #2
    No way Guest

    Default RE: Urgent!! SQL question

    and field1 = &#039;&#039;<BR><BR>only use single quotes.

  3. #3
    :) Guest

    Default THANKS!!


Posting Permissions

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