I tried that and got an error, ODBC Error Code = 37000 (Syntax error or access violation)
[Microsoft][ODBC SQL Server Driver][SQL Server]Error converting data type varchar to numeric. -----Original Message----- From: Stephen Moretti [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 20, 2001 9:55 AM To: CF-Talk Subject: Re: ORDER BY (SQL Server) James, Looks like your data type is text, in which case the order you have is correct. Changing the data type to numeric will order them in the correct numeric order. Regards Stephen ----- Original Message ----- From: "James Taavon" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, December 20, 2001 2:34 PM Subject: ORDER BY (SQL Server) > I have noticed when using an ORDER BY clause that my list sorts on first > digit of a number and not the whole number. Does the data type definition in > my database have any impact on the sort? > > Sorts like this right now:1, 10, 2, 20, 3, 30 > > instead of: 1,2,3,10,20,30 > ______________________________________________________________________ Get Your Own Dedicated Windows 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=coldfusionb 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