Thanks guys. I tried this, but was missing the spaces around the + Steve
-----Original Message----- From: Troy Sosamon [mailto:[EMAIL PROTECTED] Sent: Friday, September 05, 2003 4:24 PM To: [EMAIL PROTECTED] Subject: [RBASE-L] - RE: Syntax problem You need a string concatenator. I assume OV_Name is text. UPDATE OptionValue SET OV_SKU=('Site-' + OV_Name) WHERE OP_ID=32 Troy -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Fogelson, Steve Sent: Friday, September 05, 2003 3:15 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Syntax problem Sorry for the dumb question, but it is Friday. UPDATE OptionValue SET OV_SKU=('Site-'OV_Name) WHERE OP_ID=32 I want the text "Site-" along with the column OV_Name (no spaces) to be updated to the column OV_SKU. Tried different combinations. Keep getting errors. Thanks for the help on Friday afternoon. Steve Fogelson Internet Commerce Solutions
