Turning a negative number into 0

[DebbieChapman]

How can i turn a negative number (ie -43) in 0 in SQL 7. I've tried using the round function but am not getting anywhere.

In my view grid i want any negatives to return a 0

 

[SQLSister]

look at using the case statement

 

[DebbieChapman]

I've tried, I keep getting an error

 

[SQLSister]

Show us your code and tell us what error.

 

[JayKusch]

select IDClient, CASE WHEN Job_Hour < 0 Then 0 ELSE Job_Hour END
from Job_Transac

Thanks

J. Kusch

 

[JayKusch]

Sorry ... That was from my test table. Maybe This may be a little clearer

select MyField1,
MyField2,
CASE
WHEN MyField3 < 0
THEN 0
ELSE MyField3
END
from MyTable

Thanks

J. Kusch

 

[checkai]

what is MyField3 Defined as? Also, I would give the 3rd record returned a Name...

select MyField1,
MyField2,
CASE WHEN MyField3 < 0 THEN 0 ELSE MyField3 END AS MyField3

from MyTable

DLC

 

[SemperFiDownUnda]

Ok I see the code...what was the error?


Hope I've been helpful,
Wayne Francis

If you want to get the best response to a question, please check out FAQ222-2244 first