set ActualRegex = REPLACE(ActualRegex, ActualRegex, ActualRegex + '[dD]*')

Msg 8152, Level 16, State 14, Line 1
String or binary data would be truncated.
The statement has been terminated.

update [Registration].[dbo].[MigrationOfTagTypes] set ActualRegex =
REPLACE(ActualRegex, ActualRegex, ActualRegex + '[dD]*')
where Regex != '' and Regex like '%%' escape ''

Msg 8152, Level 16, State 14, Line 1
String or binary data would be truncated.
The statement has been terminated.

update [Registration].[dbo].[MigrationOfTagTypes] set ActualRegex =
RTRIM(REPLACE(ActualRegex, ActualRegex, ActualRegex + '[dD]*'))
where Regex != '' and Regex like '%%' escape ''

update [Registration].[dbo].[MigrationOfTagTypes]
set ActualRegex = RTRIM(ActualRegex) + '[dD]*'
where Regex != '' and Regex like '%%' escape ''