Home Forums SQL Server 2005 Administering Msg 8152, Level 16, State 14, Line 1,String or binary data would be truncated. RE: Msg 8152, Level 16, State 14, Line 1,String or binary data would be truncated.

  • April 30, 2009 at 7:11 am

    #986627

    Krasavita (4/30/2009)

    When I ran this statment I get this error:

    Msg 8152, Level 16, State 14, Line 1

    String or binary data would be truncated.

    The statement has been terminated. What is wrong with this statment?

    UPDATE TblCust

    SET

    tblCust.LAST_NAME =

    SUBSTRING(FIRST_NAME, CHARINDEX(' ', FIRST_NAME) + 1, 100) + LAST_NAME,

    tblCust.first_NAME =

    SUBSTRING(FIRST_NAME, 1, CHARINDEX(' ', FIRST_NAME + ' ') - 1)

    FROM dbo.TblCust

    WHERE (FIRST_NAME LIKE '%-')

    It looks like the LAST_NAME field is getting appended each time, which is leading to the value becoming too long for that field; that's probably the source of the problem.