SQL Update for part of a field.

["Jim Essinger" <dilbernator@xxxxxxxxx>]

Ok SQL gurus,

I have a field that is very long, but I only want to update a part of the
field.  The statment I have is this;

update libname/filename
 set substr(fieldname,2,3) = '225'
where substr(fieldname,1,1) in ('5', '8')

The error says.

Token ( was not valid. Valid tokens: =.

Can you use UPDATE to set a portion of a field and leave the rest of the
field alone?

Thanks!


Jim Essinger