Hai

I discover a new thing.
In Microsoft Access,the datatype Currency is available to choose.However in SQL Server 2000,we can only choose money.

Is it possible to do it in SQL Server 2000 for the datatype involve price, i mean money?

Another problem, if in my database, in the price column,i keep all my products's price, let say as RM100.00.
so, in my web page then, i hope to see the product price also RM100.00.
So, how should i design my database now, i mean the datatype for the price .
thanks.

The SQL Server 2000 data type you should use to store monetry values (e.g. price) is money. This is roughly equivalent to Access's Currency data type. You can store monetry values with a precision of (I think) 4 decimal places using the SQL Server money data type. All you will need to do to display this value on your web page (or any client application for that matter) is read the value and add the money sign (e.g. €, RM, £, $, etc.) to the front of it. I hope this answers your questions.

Regards
Owain Williams