Yes that's correct. In SQL Server you need to pick the right datatype for you data vs. choosing a length. If you are trying to restrict the length then do it in your data entry form (which you should do anyways...but I digress).
To get up to speed on SQL Server datatypes you should have a look in the Online Books that comes with SQL Server. There is a very good decsription of each type. HTH Bryan Stevenson VP & Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] --------------------------------------------------------- Macromedia Associate Partner www.macromedia.com --------------------------------------------------------- Vancouver Island ColdFusion Users Group Founder & Director www.cfug-vancouverisland.com ----- Original Message ----- From: <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, February 19, 2002 1:57 PM Subject: Re: Datatypes > None of those number datatypes let me specify the length. Any > recommendations on what datatype to use that will let me specify the length > (for numbers)? > > ----- Original Message ----- > From: "Bryan Stevenson" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Tuesday, February 19, 2002 2:52 PM > Subject: Re: Datatypes > > > > text = varchar or nvarchar > > number = integer (but can be split into float, smallint, decimal, tinyint > depending on the actual > > data you're storing) > > > > I think that got them all ;-) > > > > HTH > > > > Bryan Stevenson > > VP & Director of E-Commerce Development > > Electric Edge Systems Group Inc. > > p. 250.920.8830 > > e. [EMAIL PROTECTED] > > --------------------------------------------------------- > > Macromedia Associate Partner > > www.macromedia.com > > --------------------------------------------------------- > > Vancouver Island ColdFusion Users Group > > Founder & Director > > www.cfug-vancouverisland.com > > > > ----- Original Message ----- > > From: <[EMAIL PROTECTED]> > > To: "CF-Talk" <[EMAIL PROTECTED]> > > Sent: Tuesday, February 19, 2002 1:43 PM > > Subject: Datatypes > > > > > > > What are the equivalents of Accesses "text" and "number" datatypes in > SQL > > > Server? > > > > > > ______________________________________________________________________ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists