Ding dang diddly! Thats right on the money. I was trying to make it more diffuclt than it needed to be. :)
Thanks much Christian Phillip B ----- Original Message ----- From: <[EMAIL PROTECTED]> To: "SQL" <[EMAIL PROTECTED]> Sent: Friday, February 14, 2003 4:20 PM Subject: RE: HELP!!!! update question > That's right. All this will do is add an F to the front of the string, > where the string currently begins with a W ... I believe that is what you > needed, right. > > Thank You, > Christian Watt > Webmaster > SkillPath Seminars > [EMAIL PROTECTED] > > > -----Original Message----- > From: Phillip B [mailto:[EMAIL PROTECTED]] > Sent: Friday, February 14, 2003 4:15 PM > To: SQL > Subject: Re: HELP!!!! update question > > So this just prepends an f to the field without the select? Cool. > > Phillip B > ----- Original Message ----- > From: <[EMAIL PROTECTED]> > To: "SQL" <[EMAIL PROTECTED]> > Sent: Friday, February 14, 2003 4:12 PM > Subject: RE: HELP!!!! update question > > > > UPDATE Table > > SET dealernumber = 'F' + dealernumber > > WHERE (LEFT(dealernumber, 1) = 'B') > > > > Thank You, > > Christian Watt > > Webmaster > > SkillPath Seminars > > [EMAIL PROTECTED] > > > > > > -----Original Message----- > > From: Phillip B [mailto:[EMAIL PROTECTED]] > > Sent: Friday, February 14, 2003 4:04 PM > > To: SQL > > 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 Get the mailserver that powers this list at http://www.coolfusion.com
