Substring

The substrings of "button" include "butt", "ton", and "on".

If an existing character-based column is increased in size and your program does not need the extra characters, the view can be changed to force the smaller size by substringing the existing column.

In this example, knowing that MY_SOUNDEX returns at most six characters, we are substringing the first six characters.