Search code examples
sql-serverappendlog-rotation

SQL Server - append text field with rotation

Let's say I have nvarchar(300) column.

I append the text as follows:

update tablename set fieldname = fieldname + 'appended string'

How can I tell SQL Server to automatically trim the text from beginning to ensure it never exceeds the maximum column length?

Solution

  • You could use the RIGHT function for that:

    update tablename set fieldname = RIGHT(fieldname + N'appended string', 300)