http://db4free.blogspot.com/2006/06/sorting-of-numeric-values-mixed-with.html
On 1/25/07, Chad Gray <[EMAIL PROTECTED]> wrote: > > You got me pointed in a great new direction. I will figure out the > details and if there is a better function then isNumeric for the data I am > dealing with. > > Thanks! > > > -----Original Message----- > From: Jim Wright [mailto:[EMAIL PROTECTED] > Sent: Thursday, January 25, 2007 10:18 AM > To: CF-Talk > Subject: Re: SQL order by > > Jim Wright wrote: > > I should point out one issue with the way I did it...the isnumeric > > function is not perfect, and will resolve to true things that can't be > > converted to INT...case in point... > > > > IsNumeric('1,0.') = 1 > > CAST('1,0.' AS INT) throws an error > > > > and further, you need to look at the numeric data you are > converting...is it all ints...you may need to convert to something > else...also, you can google on isreallynumeric and > isreallyinteger...those are some custom functions I've used in the past. > > sorry about the multiple posts...headache...not thinking clearly. > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267663 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
