UPDATE PSQRYDEFN      set qryname = replace(qryname,'XGL','ZGL') where qryname in (select objectvalue1 from psprojectitem where projectname = 'VCR_QUERIES_BM');
UPDATE PSQRYDEFNLANG  set qryname = replace(qryname,'XGL','ZGL') where qryname in (select objectvalue1 from psprojectitem where projectname = 'VCR_QUERIES_BM');
UPDATE PSQRYBIND      set qryname = replace(qryname,'XGL','ZGL') where qryname in (select objectvalue1 from psprojectitem where projectname = 'VCR_QUERIES_BM');
UPDATE PSQRYBINDLANG  set qryname = replace(qryname,'XGL','ZGL') where qryname in (select objectvalue1 from psprojectitem where projectname = 'VCR_QUERIES_BM');
UPDATE PSQRYCRITERIA  set qryname = replace(qryname,'XGL','ZGL') where qryname in (select objectvalue1 from psprojectitem where projectname = 'VCR_QUERIES_BM');
UPDATE PSQRYEXPR      set qryname = replace(qryname,'XGL','ZGL') where qryname in (select objectvalue1 from psprojectitem where projectname = 'VCR_QUERIES_BM');
UPDATE PSQRYFIELD     set qryname = replace(qryname,'XGL','ZGL') where qryname in (select objectvalue1 from psprojectitem where projectname = 'VCR_QUERIES_BM');
UPDATE PSQRYFIELDLANG set qryname = replace(qryname,'XGL','ZGL') where qryname in (select objectvalue1 from psprojectitem where projectname = 'VCR_QUERIES_BM');
--UPDATE PSQRYFLAGS     set qryname = replace(qryname,'XGL','ZGL') where qryname in (select objectvalue1 from psprojectitem where projectname = 'VCR_QUERIES_BM');
UPDATE PSQRYLINK      set qryname = replace(qryname,'XGL','ZGL') where qryname in (select objectvalue1 from psprojectitem where projectname = 'VCR_QUERIES_BM');
UPDATE PSQRYRECORD    set qryname = replace(qryname,'XGL','ZGL') where qryname in (select objectvalue1 from psprojectitem where projectname = 'VCR_QUERIES_BM');
UPDATE PSQRYSELECT    set qryname = replace(qryname,'XGL','ZGL') where qryname in (select objectvalue1 from psprojectitem where projectname = 'VCR_QUERIES_BM');

update psprojectitem set objectvalue1 = replace(objectvalue1,'XGL','ZGL') where projectname = 'VCR_QUERIES_BM';