一、LPAD左侧补齐
LPAD(string,length,padstring) -- (字符串,长度,填补什么字符串)
示例:
SELECT volcode,LPAD(volcode,3,0) FROM volume WHERE volcode IS NOT NULL --当length大于要补的位数时,volcode会自动从后面去掉多余位数
SELECT archcode,LPAD(SUBSTRING(archcode,'-',-1),4,0) FROM volume WHERE archcode IS NOT NULL
运行结果:
二、RPAD右侧补齐
RPAD(string,length,padstring) -- (字符串,长度,填补什么字符串)
示例:
SELECT volcode,RPAD(volcode,3,0) FROM volume WHERE volcode IS NOT NULL --当length大于要补的位数时,volcode会自动从后面去掉多余位数
SELECT archcode,RPAD(SUBSTRING(archcode,'-',-1),4,0) FROM volume WHERE archcode IS NOT NULL
运行结果: