Post reply

Please help qith SQL

  • 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.

     

  • September 27, 2005 at 11:29 am

    #593380

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

  • 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...

  • September 27, 2005 at 11:40 am

    #593385

    If you say so ...

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply