Toad World® Forums

Do not appear decimals value

When I tried do calculation where the result are in decimals, this are not displaying. (SQL EXPRESS)

I tried:

select cast(3/4 as decimal(8,2)) example

but the result is

example

0.00

and the real value do not appear

I´ve solved this:

select 3/cast(4 as float) as example