<strong>PLSQL:标准函数<br></strong>Select Lpad(''1'',10,''0'') From Table;<br>1的右边插入10个''0''字符.<br>Select Rpad(''1'',10,''0'') From Table;<br>1的左边插入10个''0''字符.<br><br><strong>TSQL:自己写的<br><br></strong>SELECT <br> Replace(space(10-len(Column)),'' '',''0'') <br> Column<br>From Table<br>将Column不足10位的0补齐。<br>