Hi David, I thought that the data you mentioned was an example of how the data was being displayed and then how it should be displayed. I sent that. And, I think Option 1 included adding zeros, which will not always work, as I explained. I know that I can get IsNumbric() to work in an If statement, but so far not in a query. Did my query look like it was right? Were the parenthisis in the right places?
Thanks, Lewis -----Original Message----- From: Dave Phillips <[EMAIL PROTECTED]> To: cf-newbie <[email protected]> Sent: Wed, 29 Oct 2008 1:10 pm Subject: RE: Numerical order of query results Lewis, aybe isNumeric() isn't available in your version of SQL Server? That's the nly thing I can think of to explain the error you are getting. Did you try the first option? I think that is the better option. I don't think he below is going to give you what you want. Also, if option 1 didn't work, end over that data I mentioned and I think we can figure it out then. ave ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-newbie/message.cfm/messageid:4111 Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
