Converting Integer to Text

• sdnkosi-735203

  SSC-Addicted

  Points: 452

  More actions

  May 13, 2008 at 4:54 am

  #186474

  Hi,

  I am trying to convert an integer to text in a query using:

  CASE WHEN [Extension]<'80' THEN '0' + CAST( Extension AS text(12)) ELSE [Extension] END AS Extn

  but I get the following error:

  'Explicit conversion from data type int to text is not allowed'

  Any suggestions? I dont want to convert the Table

• RyanRandall

  SSChampion

  Points: 13623

  More actions

  May 13, 2008 at 5:07 am

  #814339

  Use varchar rather than text?

  Ryan Randall

  Solutions are easy. Understanding the problem, now, that's the hard part.

• sdnkosi-735203

  SSC-Addicted

  Points: 452

  More actions

  May 13, 2008 at 5:16 am

  #814342

  Hi,

  The '0' is not added when I use varchar

• Dharmalinga

  Mr or Mrs. 500

  Points: 503

  More actions

  May 13, 2008 at 5:19 am

  #814345

  hi

  Try this

  CASE WHEN [Extension]<'80' THEN '0' + CAST( Extension AS varchar(12)) ELSE [Extension] END AS Extn

• Sergiy

  SSC Guru

  Points: 110209

  More actions

  May 13, 2008 at 5:23 am

  #814347

  It must be [Extension]<80, not [Extension]<'80' .

  _____________
  Code for TallyGenerator

• sdnkosi-735203

  SSC-Addicted

  Points: 452

  More actions

  May 13, 2008 at 5:30 am

  #814350

  Still no luck

• Dharmalinga

  Mr or Mrs. 500

  Points: 503

  More actions

  May 13, 2008 at 5:46 am

  #814362

  Try This

  CASE WHEN [Extension]<80 THEN '0'+ CAST(Extension as VARCHAR(12)) ELSE CAST(Extension as VARCHAR(12)) END AS Extn

• sdnkosi-735203

  SSC-Addicted

  Points: 452

  More actions

  May 13, 2008 at 5:56 am

  #814371

  Thank you all it works