Look in SQL BOL for decimal. Keep in mind the PRECISION and SCALE. David L. Penton, Microsoft MVP JCPenney Application Specialist / Lead "Mathematics is music for the mind, and Music is Mathematics for the Soul. - J.S. Bach" [EMAIL PROTECTED]
Do you have the VBScript Docs or SQL BOL installed? If not, why not? VBScript Docs: http://www.davidpenton.com/vbscript SQL BOL: http://www.davidpenton.com/sqlbol -----Original Message----- From: Sam Thompson [mailto:[EMAIL PROTECTED]] Hi In access I can set the field size of a number datatype to be "Double", now im creating the same table in SQL Server 7, what do I put in my SQL script (which creates the table) to make the equivalent field? Currently ive got: CREATE TABLE tblData ( [ID] numeric IDENTITY(1,1), [Section] varchar (255) NULL, [Content] text NULL, [SectionNo] int , <---------- what goes here to make it double? [DateUpdated] datetime, [DateSent] datetime ) Thanks! Sam --- You are currently subscribed to activeserverpages as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED]
