update x10types set on_graphic = 'c:\powerhome\' || substr(on_graphic,28) where substr(on_graphic,1,27) = 'c:\program files\powerhome\';
update x10types set off_graphic = 'c:\powerhome\' || substr(off_graphic,28) where substr(off_graphic,1,27) = 'c:\program files\powerhome\';
update x10types set dim_graphic = 'c:\powerhome\' || substr(dim_graphic,28) where substr(dim_graphic,1,27) = 'c:\program files\powerhome\';
update x10types set unk_graphic = 'c:\powerhome\' || substr(unk_graphic,28) where substr(unk_graphic,1,27) = 'c:\program files\powerhome\';
update digitaltypes set on_graphic = 'c:\powerhome\' || substr(on_graphic,28) where substr(on_graphic,1,27) = 'c:\program files\powerhome\';
update digitaltypes set off_graphic = 'c:\powerhome\' || substr(off_graphic,28) where substr(off_graphic,1,27) = 'c:\program files\powerhome\';
update analogio set graphic = 'c:\powerhome\' || substr(graphic,28) where substr(graphic,1,27) = 'c:\program files\powerhome\';
update insteontypes set on_graphic = 'c:\powerhome\' || substr(on_graphic,28) where substr(on_graphic,1,27) = 'c:\program files\powerhome\';
update insteontypes set off_graphic = 'c:\powerhome\' || substr(off_graphic,28) where substr(off_graphic,1,27) = 'c:\program files\powerhome\';
update insteontypes set dim_graphic = 'c:\powerhome\' || substr(dim_graphic,28) where substr(dim_graphic,1,27) = 'c:\program files\powerhome\';
update insteontypes set unk_graphic = 'c:\powerhome\' || substr(unk_graphic,28) where substr(unk_graphic,1,27) = 'c:\program files\powerhome\';
update upbtypes set on_graphic = 'c:\powerhome\' || substr(on_graphic,28) where substr(on_graphic,1,27) = 'c:\program files\powerhome\';
update upbtypes set off_graphic = 'c:\powerhome\' || substr(off_graphic,28) where substr(off_graphic,1,27) = 'c:\program files\powerhome\';
update upbtypes set dim_graphic = 'c:\powerhome\' || substr(dim_graphic,28) where substr(dim_graphic,1,27) = 'c:\program files\powerhome\';
update upbtypes set unk_graphic = 'c:\powerhome\' || substr(unk_graphic,28) where substr(unk_graphic,1,27) = 'c:\program files\powerhome\';
update cctabs set bkgrnd_bmp = 'c:\powerhome\' || substr(bkgrnd_bmp,28) where substr(bkgrnd_bmp,1,27) = 'c:\program files\powerhome\';
update ccbuttons set filepath_up = 'c:\powerhome\' || substr(filepath_up,28) where substr(filepath_up,1,27) = 'c:\program files\powerhome\';
update ccbuttons set filepath_down = 'c:\powerhome\' || substr(filepath_down,28) where substr(filepath_down,1,27) = 'c:\program files\powerhome\';
update ccbuttonstemp set filepath_up = 'c:\powerhome\' || substr(filepath_up,28) where substr(filepath_up,1,27) = 'c:\program files\powerhome\';
update ccbuttonstemp set filepath_down = 'c:\powerhome\' || substr(filepath_down,28) where substr(filepath_down,1,27) = 'c:\program files\powerhome\'; 