how to make a left space in a nchar(2) word?

Asked Aug 29 '16 at 12:19

Active Aug 29 '16 at 12:21

Viewed 36 times

I want to select a month from a column CMonth but I want to preview it as :- 01,02,03,04,05,06,07,08,09,10,11,12.
I wrote this code but it preview it as :-
10 , 20 , 30 , 40 , 50 , 60 .... 10,11,12

SELECT 
    RTRIM(LTRIM(REPLACE(CAST(CMonth AS NCHAR(2)),' ','0'))) 
from tablename

edited Aug 29 '16 at 12:21

Praveen

8,945
4
31
49

asked Aug 29 '16 at 12:19

Bishoy Ezzat

Can you show the sample data of your table? – Sankar Aug 29 '16 at 12:21
aha it is 1,2,3,4,5,6,7,8,9,10,11,12 without zeros @SankarRaj – Bishoy Ezzat Aug 29 '16 at 12:24
it got marked as duplicate.. anyway you can use the following code.. SELECT CASE WHEN CMonth <10 THEN '0'+CAST(CMonth as VARCHAR(10)) ELSE CAST(CMonth as VARCHAR(10)) END AS CMonth from tablename – Unnikrishnan R Aug 29 '16 at 12:25
I think i found it thanks :) – Bishoy Ezzat Aug 29 '16 at 12:27
@BishoyEzzat: Look at your question, the duplicate is linked: _"This question already has an answer here: [PadLeft function in T-SQL](http://stackoverflow.com/questions/5540064/padleft-function-in-t-sql)"_ – Tim Schmelter Aug 29 '16 at 12:29
yes I did .. thanks :) – Bishoy Ezzat Aug 29 '16 at 12:32

how to make a left space in a nchar(2) word?

0 Answers0