Home Forums SQL Server 7,2000 T-SQL String or binary data would be truncated.The statement has been terminated. RE: String or binary data would be truncated.The statement has been terminated.

  • August 9, 2010 at 7:26 am

    #1204155

    In my CASE statement I want my results to be limited to 30 characters.

    So in the ELSE part of the statement I have

    ELSE PROP.postcode + N'/' + PROP.address, it is this that I want limited.

    Thanks

    Ryan