What is the proper data type to use for a numeric comparison? My situation is this: I have a two decimal place dollar amount field that is set to varchar in the database, and need to convert it to another data type so that users can search for items where the amount is greater than, less than, or equal to an amount they define. I've tried all data types with no satisfactory results. Any suggestions? Thank you.