I want to update 160 records in a table. The field contains a variable value
and a constant prefex like
'constant: unique value for this record'
Is there such an UPDATE statement that would update this field into
'unique value for this record'
They way I would do it otherwise is using Perls
Thanks Karel,
This worked almost out of the box, just needed to find out that 'len+1' has
to be replaced with the actual number and is not automatically set (like len
= length('CONSTANT%'). But the manual also explains this very well, I just
didn't think of substring.
Hannes
On 7/3/01 9:13 AM,