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

  • October 14, 2009 at 4:46 am

    #1065579

    Does this help?

    DECLARE @str NVARCHAR(10)

    SET @str = 'ABCDEFGHI'

    SELECT substring(@str, 1, len(@str) - 3) + ' ' + right(@str, 3)

    Cheers,

    J-F