the MS SQL Server data type that is best for this field will be varchar. What I want to do, though, is if the values in a serial number field for a given query are all numeric values, I'd like to ...

I have some tables that store dollar amounts, among other data. I had the fields set to be a data type of money ... BR><BR>So, is there a way to get SQL Server 2000 to return 0.00 as the value ...