Understanding column splitting

["Riesland, Zack" <Za...@sensus.com>]

I want to make sure that I'm splitting my columns as effectively as possible, and I want to make sure I understand the syntax.

Suppose I have a table that is 'split on' ('XXXX_B0',  'XXXX_B1', 'XXXX_B2',  'XXXX_B3',  'XXXX_B4',  'XXXX_B5',  'XXXX_B6',  'XXXX_B7',  'XXXX_B8',  'XXXX_B9', 'YYYY_B0', 'YYYY_B1'...)

If I upsert  a row with key 'XXXX_B0912', it will go into the first region ('XXXX_B0'). Correct? (aside from the fact that these regions could eventually split, etc)

Likewise, a row with key 'XXXX_B3Z' will go in the region 'XXXX_B3', and a row with key 'XXXX_BXXX', it will go into region 'XXXX_B9', correct?

Thanks!