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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
