--------------------------------------------------
_worldbaan
_countryban
_districtban
_internationalban

--------------------------------------------------
worldbaank
countrybank
districtbank
internationalbank

IF object_id('tempdb..#testEnvironment') IS NOT NULL
BEGIN
    DROP TABLE #testEnvironment;
END;

CREATE TABLE #testEnvironment (last_name VARCHAR(50));

INSERT INTO #testEnvironment
SELECT last_name
FROM (VALUES ('abc_worldbaank'),
             ('xyzabc_countrybank'),
             ('yyybb_districtbank'),
             ('zzzaaa_internationalbank')
     ) a(last_name);

IF object_id('tempdb..#testEnvironment') IS NOT NULL
BEGIN
    DROP TABLE #testEnvironment;
END;

CREATE TABLE #testEnvironment (last_name VARCHAR(50));

INSERT INTO #testEnvironment
SELECT 'abc_worldbaank'
UNION ALL SELECT 'xyzabc_countrybank'
UNION ALL SELECT 'yyybb_districtbank'
UNION ALL SELECT 'zzzaaa_internationalbank';

SELECT SUBSTRING(last_name, CHARINDEX('_', last_name) + 1, 50)
FROM #testEnvironment;

--------------------------------------------------
worldbaank
countrybank
districtbank
internationalbank

SELECT SUBSTRING(last_name, CHARINDEX('_', last_name), 50)
FROM #testEnvironment;

--------------------------------------------------
_worldbaank
_countrybank
_districtbank
_internationalbank

select parsename(replace(last_name,'_','.'),1)

select substring(last_name, charindex('_',last_name) + 1, len(last_name))

IF object_id('tempdb..#testEnvironment') IS NOT NULL
BEGIN
    DROP TABLE #testEnvironment;
END;

CREATE TABLE #testEnvironment (last_name VARCHAR(50));

INSERT INTO #testEnvironment
SELECT last_name
FROM (VALUES ('abc_worldbaank'),
             ('xyzabc_countrybank'),
             ('yyybb_districtbank'),
             ('zzzaaa_internationalbank')
     ) a(last_name);
go

select
    *
from
    #testEnvironment
    cross apply dbo.DelimitedSplit8K(last_name,'_')
where
    ItemNumber = 2;
go

IF object_id('tempdb..#testEnvironment') IS NOT NULL
BEGIN
    DROP TABLE #testEnvironment;
END;