[cfaussie] Re: Zero suppression

[Lindsay Evans]

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

not if your variable is '120' :)   --  Lindsay Evans.  Developer,  Red Square Productions.  [p] 8596.4000  [f] 8596.4001  [w] www.redsquare.com.au -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Phil McCluskey Sent: Friday, February 28, 2003 3:23 PM To: CFAussie Mailing List 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/