List:General Discussion« Previous MessageNext Message »
From:Mester József Date:January 6 2006 9: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 QuestionMester József6 Jan
  • Re: SQL QuestionGleb Paharenko6 Jan
  • Re: SQL QuestionRhino6 Jan
Re: SQL QuestionMester József6 Jan