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:02 am

    #1204137

    Ryan

    That all depends on your requirements. Here's one way (not tested):

    ...

    LEFT(COALESCE(PROP.postcode + N'/','') + PROP.address ,30)

    ...

    John