Home Forums SQL Server 2016 SQL Server 2016 - Development and T-SQL Update the first and last 2 charactors with year and month RE: Update the first and last 2 charactors with year and month

  • February 21, 2018 at 11:57 am

    #1980666

    Can you help explain the script?  

    Can you help explain this part of the script. 

    SELECT modified_string=STUFF(LEFT(CONVERT(VARCHAR,GETDATE(),12),4),3,0,

    This is the length that starts at position 3 then you subtract 4 characters to remove the first and last 2 characters of the value 
    SUBSTRING(some_string,3,LEN(some_string)-4))