As Sergey puts it, (5,2). I don't see a default value being added though.

>>Works for me. Did you added the column after the fact?
>>
>>What's your column definition? (Create Table syntax)
>

>/****** 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]
>GO

>
>I see the problem. It should be 5,2 instead of 2.0 That's my problem. How should I do it table designer?
>
>BTW, the thread title should say data, not date. I appologize.