depending on your table structure you should be able to use one of update (select statement) set col1=newval or update profile customers set sp_type_cd=( select statement) where exists( select statement); -- Niall Litchfield Oracle DBA http://www.niall.litchfield.dial.pipex.com -- //www.freelists.org/webpage/oracle-l