Add to Alpha Values

• bnordberg

  SSCertifiable

  Points: 5480

  More actions

  May 1, 2003 at 3:43 pm

  #158884

  I need to create a list of values such as

  Field 1 Field 2

  AA BI

  BJ CC

  CD DF

  I can get

  Field 1 Field 2

  AA BI

  BI CC

  CC DF

  Is there a way to add 1 alpha digit to the field 1? Something like field1+1 so BI=BJ

  Thanks

  Brian

• Andy Warren

  SSC Guru

  Points: 119902

  More actions

  May 1, 2003 at 4:01 pm

  #455944

  Something close to this:

  char(asc(right(colname,1))+1)

  Andy

  http://www.sqlservercentral.com/columnists/awarren/

  Andy
  SQLAndy - My Blog!
  Connect with me on LinkedIn
  Follow me on Twitter

• Antares686

  SSC Guru

  Points: 125444

  More actions

  May 1, 2003 at 5:10 pm

  #455949

  Andy meant

  char(ascii(right(colname,1))+1)

  he just typoed.