SQL server field size issue

[rkrause]

I have a field in my query that are like this
1
2
3
4
5
6
7
8
9
10
11
ect, but i want to know if there is away to make a field 2 digits so that my sigle digits will be 01,02,03, ect and then 10 11, 12 will stay the same?

 

[pbaldy]

In Access or SQL Server? In Access fairly easy with the Format() function:

Format(FieldName, "00")

In T-SQL, a little more complicated. Here's one thread:

http://social.msdn.microsoft.com/Fo...s/thread/faf71ca6-ccf6-4661-8569-3656ce7dd290

 

[SQL_Hell]

Here is some sample code that would do that, you will need a text based field


DECLARE @num varchar(10)

SET @num= '1'

INSERT INTO table_1
(id)

SELECT CASE WHEN LEN(@num) = 1 THEN '0' + @num ELSE @num END