SQL Server 2016

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE [dbo].[Accounts](
	[Account] [int] NOT NULL,
	[SubAcct] [int] NOT NULL,
	[SubSubAcct] [int] NOT NULL,
	[SubSubSubAcct] [int] NOT NULL,
	[AccountNumber] [varchar](12) NOT NULL,
	[Name] [varchar](18) NOT NULL,
);

Alter Table Accounts add [HierID] as convert(hierarchyid,'/'+replace(AccountNumber,'-','/')+'/')  PERSISTED;

INSERT INTO Accounts
    ([Account], [SubAcct], [SubSubAcct], [SubSubSubAcct], [AccountNumber], [Name])
VALUES
    (1110, 0, 0, 0, '1110', 'Banks'),
    (1110, 1, 0, 0, '1110-1', 'US Banks'),
    (1110, 1, 1, 0, '1110-1-1', 'Bank One'),
    (1110, 1, 1, 1, '1110-1-1-1', 'Bank One #123456'),
    (1110, 1, 1, 2, '1110-1-1-2', 'Bank One #234567'),
    (1110, 1, 1, 11, '1110-1-1-11', 'Bank One #11223344'),
    (1110, 1, 2, 0, '1110-1-2', 'Bank Two'),
    (1110, 1, 2, 1, '1110-1-2-1-1', 'Bank Two #876543'),
    (1110, 2, 0, 0, '1110-2', 'Foreign Banks'),
    (1110, 2, 1, 0, '1110-2-1', 'Japan One #556677'),
    (1120, 0, 0, 0, '1120', 'Receivables'),
    (1120, 1, 0, 0, '1120-1', 'US Receivables'),
    (1120, 1, 1, 0, '1120-1-1', 'Zone One'),
    (1120, 1, 1, 1, '1120-1-1-1', 'Customer AAA'),
    (1120, 1, 1, 2, '1120-1-1-2', 'Customer BBB'),
    (1120, 1, 1, 3, '1120-1-1-3', 'Customer CCC'),
    (1120, 1, 2, 0, '1120-1-2', 'Zone Two'),
    (1120, 1, 2, 1, '1120-1-2-1', 'Customer WWW'),
    (1120, 1, 2, 2, '1120-1-2-2', 'Customer YYY')
;

Select * from Accounts

Account	SubAcct	SubSubAcct	SubSubSubAcct	AccountNumber	Name	HierID
1110	0	0	0	1110	Banks	/1110/
1110	1	0	0	1110-1	US Banks	/1110/1/
1110	1	1	0	1110-1-1	Bank One	/1110/1/1/
1110	1	1	1	1110-1-1-1	Bank One #123456	/1110/1/1/1/
1110	1	1	2	1110-1-1-2	Bank One #234567	/1110/1/1/2/
1110	1	1	11	1110-1-1-11	Bank One #11223344	/1110/1/1/11/
1110	1	2	0	1110-1-2	Bank Two	/1110/1/2/
1110	1	2	1	1110-1-2-1-1	Bank Two #876543	/1110/1/2/1/1/
1110	2	0	0	1110-2	Foreign Banks	/1110/2/
1110	2	1	0	1110-2-1	Japan One #556677	/1110/2/1/
1120	0	0	0	1120	Receivables	/1120/
1120	1	0	0	1120-1	US Receivables	/1120/1/
1120	1	1	0	1120-1-1	Zone One	/1120/1/1/
1120	1	1	1	1120-1-1-1	Customer AAA	/1120/1/1/1/
1120	1	1	2	1120-1-1-2	Customer BBB	/1120/1/1/2/
1120	1	1	3	1120-1-1-3	Customer CCC	/1120/1/1/3/
1120	1	2	0	1120-1-2	Zone Two	/1120/1/2/
1120	1	2	1	1120-1-2-1	Customer WWW	/1120/1/2/1/
1120	1	2	2	1120-1-2-2	Customer YYY	/1120/1/2/2/

Account	SubAcct	SubSubAcct	SubSubSubAcct	AccountNumber	Name	HierID
1110	0	0	0	1110	Banks	/1110/
1110	1	0	0	1110-1	US Banks	/1110/1/
1110	1	1	0	1110-1-1	Bank One	/1110/1/1/
1110	1	1	1	1110-1-1-1	Bank One #123456	/1110/1/1/1/
1110	1	1	2	1110-1-1-2	Bank One #234567	/1110/1/1/2/
1110	1	1	11	1110-1-1-11	Bank One #11223344	/1110/1/1/11/
1110	1	2	0	1110-1-2	Bank Two	/1110/1/2/
1110	1	2	1	1110-1-2-1-1	Bank Two #876543	/1110/1/2/1/1/
1110	2	0	0	1110-2	Foreign Banks	/1110/2/
1110	2	1	0	1110-2-1	Japan One #556677	/1110/2/1/
1120	0	0	0	1120	Receivables	/1120/
1120	1	0	0	1120-1	US Receivables	/1120/1/
1120	1	1	0	1120-1-1	Zone One	/1120/1/1/
1120	1	1	1	1120-1-1-1	Customer AAA	/1120/1/1/1/
1120	1	1	2	1120-1-1-2	Customer BBB	/1120/1/1/2/
1120	1	1	3	1120-1-1-3	Customer CCC	/1120/1/1/3/
1120	1	2	0	1120-1-2	Zone Two	/1120/1/2/
1120	1	2	1	1120-1-2-1	Customer WWW	/1120/1/2/1/
1120	1	2	2	1120-1-2-2	Customer YYY	/1120/1/2/2/

Account	SubAcct	SubSubAcct	SubSubSubAcct	AccountNumber	Name	HierID
1110	1	0	0	1110-1	US Banks	/1110/1/
1110	1	1	0	1110-1-1	Bank One	/1110/1/1/
1110	1	1	1	1110-1-1-1	Bank One #123456	/1110/1/1/1/
1110	1	1	2	1110-1-1-2	Bank One #234567	/1110/1/1/2/
1110	1	1	11	1110-1-1-11	Bank One #11223344	/1110/1/1/11/
1110	1	2	0	1110-1-2	Bank Two	/1110/1/2/
1110	1	2	1	1110-1-2-1-1	Bank Two #876543	/1110/1/2/1/1/