Sure, it should be fine in this case. Yes, you can order by it. 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]] 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]> > 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. > > -----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]
