[cfaussie] Re: Zero suppression

[Phil Evans]

Title: RE: [cfaussie] Re: Budget CF Server

I had thought that would change 10 to 1, which I don't want.   Any non-zero number needs to be unchanged.   I suppose I could try rereplace if I could just figure out the reg exp for a single zero digit.   Thanks, Phil. ----- Original Message ----- From: Phil McCluskey Newsgroups: cfaussie To: CFAussie Mailing List Sent: Friday, February 28, 2003 3:22 PM Subject: [cfaussie] Re: Zero suppression can't you just use replace(variable, '0','')? "Phil Evans" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED]... Hi All,   The other day we had some very clever methods for converting negatives to zero. Any one care to have a crack at converting zero to null, prior to displaying on a form? (Aside from using an IF statement).   Thanks, Phil.     --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/ --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/