---
tags: SQL
author: Anderson
---
# MSSQL字串左右補零
###### tags: `SQL`

## :memo:Code

Select 
  RIGHT(REPLICATE('0', 8) + CAST('12345' as NVARCHAR), 8) as '左邊補零'
, LEFT(CAST('12345' as NVARCHAR) + REPLICATE('0', 8), 8) as '右邊補零'

## :memo:結果