How to do in SqlServer so that the result comes with zero left?
In mysql it would look like this:
select lpad(mes,2,0 ) as 'mes', ano from tab_qualquer;
How do you do something equivalent on Sql Server?
I've already searched the link and I did so:
select distinct
right(replicate('0',2) + mes,2) as mes,
ano
from tabela
and gave the following error:
Error code 0, SQL state 22019: Unrecognized SQL escape 'year' at line position 702. Line 1, column 1
If the month field is numeric, to display with leading zero, you must show it as a string. The Error may be masking the real problem. Pass the table structure.
select distinct
right(replicate('0',2) + convert(VARCHAR,mes),2) as mes,
ano
from tabela
SEGUE:
Select REPLICATE('0', 2 - LEN(PER_CODIGO)) + RTrim(PER_CODIGO) FROM PERFIL
'0' is the character you want to repeat,
2 is the number of houses in your string,
'PER_CODIGO' is your field.
If you want the example below works great.
select RIGHT('000' + CAST('025' AS VARCHAR(10)),8)