SQL calculated value Overflow prevention 2

[techzone12]

I have T-SQL query,in which I do a calculation as follows:

SELECT CONVERT(int,
Volts * Amps * 0.001732 * PF / 100)
AS KW
FROM Elec_Table

I want the query to check if the number calculated (KW) is higher that say 1000, then to produce a null or zero.

How do I do this?

Thanks

 

[gmmastros]

SELECT Case When CONVERT(int,
Volts * Amps * 0.001732 * PF / 100) > 1000
Then 0
Else CONVERT(int,
Volts * Amps * 0.001732 * PF / 100)
End AS KW
FROM Elec_Table


-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[techzone12]

That did it.

Thanks a million!!