Hello Everybody!

I'm trying to update a table with the following update statement, but
always getting a syntax error:
UPDATE object4
CASE WHEN (position( ',' in feld4)-1) > 0 THEN SET
feld3=substring(feld4 from 1 for position( ',' in feld4)-1)
ELSE feld3=feld4
END
WHERE feld3 like 'DIVERSE%%'


Could someone help ....

Thanks
Ralf