Please help qith SQL

• El Hulk

  SSC Enthusiast

  Points: 114

  More actions

  September 27, 2005 at 11:27 am

  #168873

  This is the problem:

   

  I have a field named CitationID in a table Named CitationMaster the datatype is char(15) I need to get the last digit or character from each row in example:

  CitationID

  A123456789

  A123456788

  I need to extract the last digit like:

  CitationID       CitationIDLast

  A123456789    9

  A123456788    8

  Can you please help me to get this done?

  Thanks a lot in advance.

   

• Ninja's_RGR'us

  SSC Guru

  Points: 294069

  More actions

  September 27, 2005 at 11:29 am

  #593380

  Select right(CitationID, 1) as CitationIDLast from...

• El Hulk

  SSC Enthusiast

  Points: 114

  More actions

  September 27, 2005 at 11:36 am

  #593383

  Geezzz... that was quick... thanks a lot, I should get out of the box and look from the outside more often, he he...

  

• Ninja's_RGR'us

  SSC Guru

  Points: 294069

  More actions

  September 27, 2005 at 11:40 am

  #593385

  If you say so ...