Home Forums SQL Server 7,2000 T-SQL Select Command while dropping first 2 characters in the column RE: Select Command while dropping first 2 characters in the column

  • March 24, 2009 at 10:23 am

    #965378

    Lookup the RIGHT function in Books Online. To get the results you want, you may need to combine it with LEN to get all the string except the first two characters.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass