Oh, try CASE WHEN isNumeric(a.ClCo) = 1 I believe it returns 1 when the value is numeric. Maybe SQL Server isn't converting that to TRUE automatically.
Dave -----Original Message----- From: Dave Phillips [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 29, 2008 12:11 PM To: cf-newbie Subject: RE: Numerical order of query results Lewis, Maybe isNumeric() isn't available in your version of SQL Server? That's the only 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 the below is going to give you what you want. Also, if option 1 didn't work, send over that data I mentioned and I think we can figure it out then. Dave ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:4110 Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
