You would only need to do this if the database field is defined as a string. If it's defined as a numeric, the trim will not make any difference.
Phil. ----- Original Message ----- From: "Peter Galipo" <[EMAIL PROTECTED]> To: "CFAussie Mailing List" <[EMAIL PROTECTED]> Sent: Monday, October 27, 2003 7:49 PM Subject: [cfaussie] Conversion > If someone enters '09' into a field, is there a function to trim it to > '9'? I want to trim it to 9 before I put it in the database. > > Thanks, > > Pete > > > --- > 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/
