Home Forums SQL Server 2005 Administering extact last 3 characters from a string RE: extact last 3 characters from a string

  • June 18, 2009 at 3:43 am

    #1011571

    you could try this, it's a bit crude but works...

    declare @string varchar(50)

    SET @string = 'ABCDEFGHIJ123'

    select reverse ( substring ( reverse ( @string ) , 1 , 3 ) )