| List: | General Discussion | « Previous MessageNext Message » | |
| From: | Mester József | Date: | January 6 2006 8:42am |
| Subject: | SQL Question | ||
| View as plain text | |||
Hy I want to sum quantites but there is some data that value is negative but users didn't write the - sign before. I can decide which datas are negative. I would like something like that select sum(moved_quantities) from db if moving like 'Move-' then sum seem the move is negative else move value is positive Is it possible? Joe --------------------------------- Yahoo! Cars NEW - sell your car and browse thousands of new and used cars online search now ---------------------------------
| Thread | ||
|---|---|---|
| • SQL Question | Mester József | 6 Jan |
| • Re: SQL Question | Gleb Paharenko | 6 Jan |
| • Re: SQL Question | Rhino | 6 Jan |
| • Re: SQL Question | Mester József | 6 Jan |
