Hi Guys,

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?


Thanks in advance....