Question: Where can I find the list of default word breakers for English in sql server full text search?

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

```

There are two reasons for this:

1. Your varchar column is not large enough. Appending 7 characters to an existing 10 into a varchar(15) column won't work
2. Your column is defined as char (why?!). Char columns have implicit trailing spaces, so if you add 'ABC' to a char(10) field containing 'XYZ', it actually ends up as 'XYZ ABC' (13) which is longer than char(10).

In the 2nd case, i.e. char columns, use RTRIM

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

```

Note: using replace like this allows `'ABCxxxABC'` to become `'ABC[\d\D]*xxxABC[\d\D]*'`

If you simply wanted to `append to the end of the column`, then you would use

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

```
I'm thinking it's possible that your column is being aggregated recursively, ad infinitum. Or at least ad 512 characters.

If this is the case, you'll have to offload the current table contents into a temporary table, then use that data to perform the update back onto the original table.

I'm researching if this is possible right now.