Mike,
Use floating point numbers instead:
select 10.0 / 100.0
You are using integer constants which result in integer results and 10 / 100 as an integer is 0. Which is in your second example then cast to numeric(3,2) but there is no fractional left part to cast.
Or you have to cast at least one of your operands into numeric first:
SELECT CAST( cast(10,numeric(3,2) / 100,NUMERIC(3,2)) -- (although I don't have my SQL running right now so I can't test this before posting)
>Im trying to get the quotient for (10/100) in SQL. I run this query using SQL Query Analyzer
>
>SELECT 10/100
>
>The result displayed is 0. I also tried this query SELECT CAST((10/100),NUMERIC(3,2))
>but still, the result returned is zero.
>
>Is there another way to return the decimal value (quotient) of the query above?