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

  • October 15, 2009 at 4:33 pm

    #1066629

    another method...

    DECLARE @txt VARCHAR(20)

    SELECT @txt = 'helloALL'

    select STUFF(@txt,LEN(@txt)-2,0,' ')

    🙂