Home Forums SQL Server 2012 SQL Server 2012 - T-SQL Query to increment an alpha character suffix RE: Query to increment an alpha character suffix

  • February 27, 2018 at 12:23 pm

    #1981341

    ScottPletcher - Tuesday, February 27, 2018 12:07 PM

    Btw, I believe your last version of the code will still add 'A' to the first non-suffixed entry.

    It actually doesn't.  SUBSTRING(<any string>, 0, 1) returns the empty string.  I tested it before posting.

    Drew

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA