Hi, Mike,

If you're looking for the remainder of one number divided by another, try this...

SELECT 10 % 100, that should return 10

(check for more details in the Books online help)

If, however, you're just looking for the result of 10/100 as .10, then I believe something like SELECT ROUND(10.00 / 100.00,2) will give you .10

If you're using variables as decimals, the following should return .10 as well...

declare @n1 decimal(14,2)
declare @n2 decimal (14,2)

Set @n1 = 10
Set @n2 = 100

select @n1/@n2

Kevin