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 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
