Hi Michael,

try

insert into mytable (field1, field2,field3, field4)
select field1, field2, field3, 'XXXX' from mytable
where field4 <> 'XXXX'

You need to include the where criteria otherwise firebird will reinsert
the new records recursively, hanging your server.

Regards
Ian Newby