right string function and convert

• Tim Ellison

  SSChasing Mays

  Points: 639

  More actions

  May 7, 2003 at 6:34 am

  #80714

  Why does the following TSQL produce different results ?

  Query

  select right('00000000'+ convert(char(8),123),8)

  Results

  --------

  123

  Query

  select right('00000000'+ convert(varchar(8),123),8)

  Results

  --------

  00000123

  When I ran the sql using SQL6.5, both produced 00000123 !

  TIA

• NPeeters

  SSChampion

  Points: 12541

  More actions

  May 7, 2003 at 6:53 am

  #456385

  The CONVERT function from integer to char right pads the resulting string with spaces.

  The conversion to varchar doesn't do this, since it stores only the 'meaningful' characters.

  Why did it work in 6.5? Maybe the RIGHT function stripped the trailing spaces automatically?

• 5409045121009-7368

  SSCoach

  Points: 15740

  More actions

  May 7, 2003 at 8:08 pm

  #456471

  Have a look at ANSI_PADDING