If you add an * after the zero works (return REReplace(s,"^0*","","ALL");). This is the greedy way to do it though. I am sure there is a more elegant way. I even put in a zero in the middle of the other numbers just to make sure it did not strip it out and it did not. Just figured it would be a start.
Bruce James Smith wrote: >> CFLib.org has a UDF that does this: >> >> http://cflib.org/udf.cfm?ID=239 >> > > That wouldn't work, looking at the code for that UDF it would only > strip the first zero... > > -- > Jay > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302439 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4