use strict; my $sql='"ALTER TABLE "ARSAMS"."TCMD_HEADER" ADD CONSTRAINT FK_TCMD_HEA_OWNER_CONTAINE (CONTAINER_OWNER_CD) REFERENCES ARSAMS.CONTAINER_OWNER_CODE (CONTAINER_OWNER_CD)"'; my $fk_table_name="FK_TCMD_HEA_OWNER_CONTAINE"; $sql=~s/($fk_table_name)/$1 FOREIGN KEY/; print $sql;