none
Query filtering out blanks when using <> operator RRS feed

  • Question

  • I have a table with 6 fields. the last field is text field and has Required =No. There is some data in the field and some blanks. When I do a query with WHERE field6<>'XXXXX', it filters out 'XXXXX' as well as all the blanks. HOw do I get it to just filter out 'XXXXX' and leave the blanks?
    Monday, July 23, 2018 6:11 PM

Answers