Select Where Value

Results 1 to 2 of 2

Thread: Select Where Value

  1. #1
    Join Date
    Dec 1969

    Default Select Where Value

    I have a table (SAMPLE) where the field (CATEGORY) has either a particular category name or is just a blank field.<BR> <BR>Is there a way I can return all values that aren&#039;t blank from using this?<BR><BR>SELECT * FROM Sample WHERE Category=&#039;&#039;

  2. #2
    Join Date
    Dec 1969

    Default RE: Select Where Value

    Select * from Sample WHERE Category &#060;&#062; &#039;&#039; AND Category is not null

Posting Permissions

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