FLOAT is a representation of the number. It is not as precise as you might like, although it might not make any difference in your particular application.
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]] Thanks guys, FLOAT did the trick. Sam. ----- Original Message ----- From: "Bostrup, Tore" <[EMAIL PROTECTED]> > Float > > HTH, > Tore. > > -----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]
