select division from sysdba.account
where '' + rtrim(division) <> ''
group by division
order by division

Well it's kind of bass-ackwards. This field should be Division Of, not Division. and the name of the account should be the Division. I.e. the parent is the Division Of value, and the account name should be the Division....

Example:

the Company name at Corporate is General Motors Corporation (GMC).
The Account.Account field should be Chevrolet, a Division of General Motors Corporation.But it isn't....we\our customers put General Motors as the Account.Account field name. and Division put Chevrolet....
I worked for GE for 11 years and became a self appointed guru on this topic.....the Account should be the Division (GE Lighting). And the Division should be the Division Of (General Electric, or in the old days General Electric Company (GEC, the chime tones for NBC).

It's been this way in SLX (and other CRM programs) since 1997, so you're not alone. We create a Division_Of field varchar (128) and have the user's fill that in directly and\OR do a lookup edit control and fill in the ParentID field with the parent's AccountID and the Division of field with the Parent account's account name.

Add a Division Of lookup, change the groups, etc.