How to change a number field into a text?

Question

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Florian Reischl SSC-Dedicated Points: 37301 More actions · Answer 1

Have a look to BOL for CONVERT/CAST

Way too less information for any other answer.

hi_abhay78 SSCertifiable Points: 6265 More actions · Answer 2

Hope this example helps as you have asked a general question and not given any other information :

begin

declare @num int

set @num = 22

select cast( @num as char)

end

Abhay Chaudhary
Sr.DBA (MCITP/MCTS :SQL Server 2005/2008 ,OCP 9i)

Paul White SSC Guru Points: 150467 More actions · Answer 3

hi_abhay78 (6/25/2009)
select cast(@num as char)

Heh. Well unless you specifically need that integer as a fixed-length char(30)...

CONVERT(varchar(11), @num)

Paul