SQL 2005, Find Min Value within Same Row, but not 0

Have a SQL 2005 Table that i need to find the Min value out of three Columns but if the Value is a 0 the next highest needs to be selected. Would like to place this Min value in a new column. Like below.

What i have been able to find online is that Min will only work with across one column but i need it to work across three columns within one row. Is there a function or something like lowest, that may work?

Thanks

Col1     1QTY       2QTY       3QTY

A         0        3         7
B         10      4        200 
C          0       0        9
D         1        2        5

TO

Col1    1QTY      2QTY      3QTY      MinValue

A         0        3         7          3
B         10      4        200        4
C          0       0        9           9
D         1        2        5           1


 

Select allOpen in new window