using numbers as characters

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a field that is a character field, and "0" represents 0, " "
represents Null. The problem is that when I use <> "0" in a query it returns
all the fields with "0". If I use Is Null, then all fields are returned that
are not empty. I change the field to numeric for data analyses. Question:
Why is the query returning fields with "0" when the criteria is <> "0" ?

Thanks,
LAF
 
I'm confused. Is that field now a Text or Number datatype in the table? How
did you change the the data from Text to Number?

Are you actually storing in the "0" with quotation marks?

" " is not null. It's a space. Even "" is not null; rather it's an empty
string.

Please show the actual SQL that you are using.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Split data in field on character return 0
Top n query using Allen Browne's "ConcatRelated" 3
Windows 10 Error: 'CreateProcessWithTokenW' was not declared in this scope 2
Data Conversion Expression returns #Error 2
Testing for null 4
Query returns Arabic and/or sanskrit characters 4
How To Specify No Criteria 2
counting Null fields 3

Back
Top