I have a problem with this view....

OrdQty DespQty Value Total Profit OrdNo
100.0 0.0 4.173 417.329 100.0 044454
1.0 0.0 12.0 12.0 0.0 044454
1.0 0.0 0.0 0.0 0.0 044454
NULL 0.0 0.0 0.0 0.0 044454
NULL 0.0 0.0 0.0 0.0 044454
NULL 0.0 0.0 0.0 0.0 044454
NULL 0.0 0.0 0.0 0.0 044454

In here, how i can eliminate all the zero and null field which is not necessary to display out? i want to do it automatically, because in this DB it will always have new entry.
How to write the sql statement for this kind of problem?
Thanks!

Are you tried filtering your results using a WHERE clause? For example:
SELECT OrdQty, DespQty, Value, Total, Profit, OrdNo
FROM table
WHERE OrdQty IS NOT NULL
AND OrdQty <> 0.0

What does your current SELECT statment look like? What do you want your end results to look like?

Scott

No..my SELECT statement is just like
SELECT OrdQty, DeapQty, Value, Total, Profit, OrdNo
FROM view
WHERE OrdNo is < '99999'
But when i try to output the result to the FrontPage, it will display all the extra 0 in the NULL field(which is i dont want)

OrdQty DespQty Value Total Profit OrdNo
100.0 0.0 4.173 417.329 100.0 044454
1.0 0.0 12.0 12.0 0.0 044454
1.0 0.0 0.0 0.0 0.0 044454
NULL 0.0 0.0 0.0 0.0 044454
NULL 0.0 0.0 0.0 0.0 044454
NULL 0.0 0.0 0.0 0.0 044454
NULL 0.0 0.0 0.0 0.0 044454
So my question is how to get rid the extra zero by using the SELECT statment or IF statement?

The easiest way is to use the SELECT statment and filter the results further in the WHERE clause as I showed earlier.

WHERE OrdNo is < '99999'
AND OrdQty IS NOT NULL

This will return only the records that do not have a ) in the NULL field.