Hello,

I need to store numbers in a table between 0 and 9999,99.

What kind of type should i use?

I have tried decimal but I still get an error!

Thanks in advance,
Sven

What error? Decimal should work, but you can try Money.

The Link below has a table of Data Types and their associated ranges

http://www.teratrax.com/sql_guide/data_types/sql_server_data_types.html