> I would like to know if I can update part of a column. ie
> update myfile set substr(direct_key,1,10)='1234567890' where
> substr(direct_key,1,10)='0987654321';
update myfile
set direct_key = '1234567890' || substring(direct_key from 11)
where substring(direct_key from 1 for 10) = '0987654321';
Note that you can use substr() also...
- Thomas