sql to convert an int to varchar

[Fang Ming]

newbie's question: how to convert an int to varchar using sql script,such as 1 ->'01' ? thanks

[subai]

i think cast & convert are easiest, declare @x int set @x = 1000; declare @y nvarchar(10) set @y = cast(@x as nvarchar) print @y set @y = convert(nvarchar,@x) print @y

---

I Wish the Life Had CTRL-Z

[Fang Ming]

ooh. i m sorry i mean how can i convert that to varchar with leading zero: 10 -> 10 0~9 -> '00' ~ '09' and it will be used in a " insert ... select ... from ..." statement. i have a table that containts a datetime column. now i want to transform the data in this to another i have to convert datetime to varchar such as : '2007-09-29 08:05'(datetime) -> '08:05' (varchar) my poor statement is "convert( varchar, datepart( hour , [DateTime] ) ) +':' +convert( varchar, datepart( minute , [DateTime]) ) " but the result is '8:5' what my boss don't want help me. thanks a lot.

[PIEBALDconsult]

How about convert(varchar(5),getdate(),8)

[Fang Ming]

Great! thank you very much!