Steve:
I think you just need to add the "+" concatenation character like this:
UPDATE OptionValue SET OV_SKU=('Site-' + OV_Name) WHERE OP_ID=32
The other concatenation character is the "&" which appends text to text but
with a space character between the two strings.
Hope that helps.
Mike Ramsour
-----Original Message-----
From: Fogelson, Steve [mailto:[EMAIL PROTECTED]
Sent: Friday, September 05, 2003 5:15 PM
To: [EMAIL PROTECTED]
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
