Colocar/Adicionar Zero / Zeros a Esquerda
Citação de Kindrazki em 29 de novembro de 2013, 09:52Colocar/Adicionar Zero / Zeros a Esquerda
[code]
DB2
Select right('0000000000'||trim(contaadebitar),10) from ....
[/code][code]
ASA Anywhere
Select right('0'||trim(contaadebitar),10) from ....
[/code][code]
Firebird
Select lpad(100, 4, '0') from rdb$database
[/code][code]
Postgres
Select lpad('1',2,'0')
[/code][code]
Sql Server
Select REPLICATE('0', 5 - LEN('033')) + RTrim('033')
[/code]
Colocar/Adicionar Zero / Zeros a Esquerda
[code]
DB2
Select right('0000000000'||trim(contaadebitar),10) from ....
[/code]
[code]
ASA Anywhere
Select right('0'||trim(contaadebitar),10) from ....
[/code]
[code]
Firebird
Select lpad(100, 4, '0') from rdb$database
[/code]
[code]
Postgres
Select lpad('1',2,'0')
[/code]
[code]
Sql Server
Select REPLICATE('0', 5 - LEN('033')) + RTrim('033')
[/code]