Question

sql 怎么判断一个字段是六位如果不足六位在前补零

Answer 1

sqlserver: select right(cast('0000000000'+rtrim(字段) as varchar(20)),7) oralce： select lpad(字段, 7 , '0') from dual

Answer 2

SELECT RIGHT('000000'+RTRIM(LTRIM(@S)),6);