第一种方法: select Replace(a.STHOUSENAME,‘仓房’,’’), a.* from eb_bms_st_store a; 第二种方法: select a.STHOUSENAME ,substr(a.STHOUSENAME,1,length(a.STHOUSENAME) -2 ) from eb_bms_st_store a