/****** Object: Table [dbo].[TaxRates] Script Date: 3/5/2003 10:28:01 AM ******/ if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TaxRates]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[TaxRates] GO /****** Object: Table [dbo].[TaxRates] Script Date: 3/5/2003 10:28:06 AM ******/ CREATE TABLE [dbo].[TaxRates] ( [State] [char] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [FullStateName] [char] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [TaxRate] [numeric](2, 0) NOT NULL ) ON [PRIMARY] GOI see the problem. It should be 5,2 instead of 2.0 That's my problem. How should I do it table designer?