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
