Hello, I have a table may contain some 0 values. And I want to use select to get the values which are not 0, of course not Null either. Does any one have some idea how to do it? Thanks in advance!!! And I am using sql sever 2000 and asp.
Your query string to select the non-zero and non-null values from the table would look something like this.
SELECT * FROM table_name WHERE column_name <> 0 AND column_name <> null
