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.
 
Back
Top