Money has a several advantages.

It handles dollars and cents

sorting money will give different (correct) results and text will not.

It possibly could be localized by an intelligent db.

It represents what the data type truly is.

Or, you could just store it as a blob :)

HTH

Dick

On Apr 5, 2004, at 6:06 PM, Dan Farmer wrote:

> This may seem obvious but I have some fields that do represent money or
>  dollars.
>
>  Should I use ( int, varchar or money ) what advantages does 'money'
> have
>  over 'int' ?
>
>  __________________________________
>  Daniel Farmer
>  Producer / Coldfusion Developer
>  http://www.bernardclark.com/danfarmer.ca
>  P: 613.284.1684
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Reply via email to