Its a small content management app, the content is split into sections and sub sections. The FLOAT field is used to store the section number, which in some cases looks like this: 2.1 I dont need to do any calculations or anything complicated with this number, will FLOAT still be ok? Can I use ORDER BY against a FLOAT field?
Thanks, Sam ----- Original Message ----- From: "David L. Penton" <[EMAIL PROTECTED]> To: "ActiveServerPages" <[EMAIL PROTECTED]> Sent: Monday, September 30, 2002 1:41 PM Subject: RE: DOUBLE > 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.unsub%% > --- You are currently subscribed to activeserverpages as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED]
