query that will ignore a certain word

[chr1stoper1]

Hi I have lots of data in a table in different fields and I would like to run a query that will return everything apart from all data fields with the word Null in.
Is this easy or shall I look to reorganise another way?

[orange]

"lots of data in a table..." makes me think you should do some research on database and table design.
Here's a tutorial that you have to work through, but you will learn about design and normalization.

NULL has special meaning in databases.

Good luck.

[NTC]

certainly if you can reorganize your data such that the word 'Null' is always found in a single field/column - that would be much more simple. The word can appear in other fields but as long as it is always in 1 field - then you only need to rely on that 1 field for your correct query.

as it is now you must set up a set of sequential queries; in each you take a field that might have the word Null and must apply the criteria: <> Null
(possibly with wild cards if the word Null is not the only word in the field i.e. *Null* )

you then have to use query1 as the source for query2 that selects a new field to have the Null criteria...and then repeat that over and over until you've covered every field that might have a null in it....