Yes, your parenthesis were correct. You have to remember though...using IsNumeric() in the SQL statement means you are using a COMPLETELY DIFFERENT FUNCTION than the IsNumeric you use in an IF statement in ColdFusion. It's a SQL Server function versus a ColdFusion function.
In any case, try the option I told you for Isnumeric() = 1. Also, I did NOT receive the example of the data. Don't know why, but it didn't come through. Dave -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 29, 2008 12:31 PM To: cf-newbie Subject: Re: Numerical order of query results 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 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:4112 Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
