how to select last two characters of a string

• want_to_know

  SSC Veteran

  Points: 256

  More actions

  April 17, 2008 at 9:42 am

  #181538

  Hi

  I need to select last two characters of a field like the field has codes

  Ex:

  abcDE

  cccDE

  bbbDE

  and i want to get the codes that has the last two characters=DE

  Thanks

• Lynn Pettis

  SSC Guru

  Points: 442467

  More actions

  April 17, 2008 at 9:44 am

  #803822

  want_to_know (4/17/2008)

  ---

  Hi

  I need to select last two characters of a field like the field has codes

  Ex:

  abcDE

  cccDE

  bbbDE

  and i want to get the codes that has the last two characters=DE

  Thanks

  declare @STR varchar(20)

  set @STR - 'abcDE'

  select right(@str,2)

  That help?

  

• want_to_know

  SSC Veteran

  Points: 256

  More actions

  April 17, 2008 at 9:51 am

  #803829

  Yes it did

  Thank you so much Lynn

  Have a wonderful day

• Jim Dillon-291542

  Hall of Fame

  Points: 3344

  More actions

  April 18, 2008 at 8:17 am

  #804387

  Just to make sure you get good data:

  RIGHT(RTRIM(LTRIM(column_name)), 2)

  With the previous example, you could have gotten a space instead of the desired two characters.