Its already in the database. After a few daily updates I need to go in and make sure they all have an f infront of the number.
----- Original Message ----- From: "Bryan Stevenson" <[EMAIL PROTECTED]> To: "SQL" <[EMAIL PROTECTED]> Sent: Friday, February 14, 2003 4:11 PM Subject: Re: HELP!!!! update question > Is the data already in the DB or is this during an INSERT or UPDATE? > > Bryan Stevenson B.Comm. > VP & Director of E-Commerce Development > Electric Edge Systems Group Inc. > t. 250.920.8830 > e. [EMAIL PROTECTED] > > --------------------------------------------------------- > Macromedia Associate Partner > www.macromedia.com > --------------------------------------------------------- > Vancouver Island ColdFusion Users Group > Founder & Director > www.cfug-vancouverisland.com > ----- Original Message ----- > From: "Phillip B" <[EMAIL PROTECTED]> > To: "SQL" <[EMAIL PROTECTED]> > Sent: Friday, February 14, 2003 2:04 PM > Subject: HELP!!!! update question > > > > I need to add an "F" to the beginning of a field where the dealernumber > begins with a "W". I have tried a few ways but can't figure it out. I'm > using SQL 2000 if that makes a difference. > > > > > > phillip B > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=6 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=6 Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
