SQL Statement HELP

Results 1 to 2 of 2

Thread: SQL Statement HELP

  1. #1
    Join Date
    Dec 1969

    Default SQL Statement HELP

    Hi all, <BR><BR>Is there a way to make a field (in MS-Access) equal anything, including NULLS? <BR><BR>i.e., SELECT * FROM Books WHERE Books.BookCategory=&#039;*&#039; or something like that? <BR><BR>Cheers, <BR>David

  2. #2
    Join Date
    Dec 1969

    Default RE: SQL Statement HELP

    Perhaps i&#039;m missing the point, but why not just miss out the WHERE clause..?<BR><BR>Or if for some reason you&#039;re insisting on having a where clause,<BR>how about "WHERE 0=0" or "WHERE Books.BookCategory = Books.BookCategory" ?

Posting Permissions

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