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 .