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 '\'

```
Is it possible that [concat](http://www.1keydata.com/sql/sql-concatenate.html) is more useful?

As far as the error message goes, I do not know why it is generated, but than again, it has been a while since I used MS SQL for the last time.