Number to string conversion

[teddysnow12]

Hi,

I have a field , end_yr_mnth which has a value like 201103 (datatype is number)


I have other field rptg_yyyymm which has a value like 2011-03
(datatype is string and format is yyyy-mm)


I need a syntax for converting either number into string or string into number to match these two fields.

 

[bborissov]

Check CAST() or CONVERT() functions in BOL.
If you want to convert string to number you must remove the hyphen, so check REPLACE() function also

Borislav Borissov
VFP9 SP2, SQL Server 2000,2005 & 2008.

 

[gmmastros]

It's probably safer to convert the number to a string because ALL numbers can be converted. Not all strings can be converted to a number.

To convert to a string and insert the hypen...

Declare @Test Int

Set @Test = 201103

Select Stuff(Convert(VarChar(6), @Test), 5, 0, '-')

-George
Microsoft SQL Server MVP
My Blogs
SQLCop
"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom