Detect Middle Spaces

Declare @T Table (Test varchar(100));

Insert Into @T
Values ('[email protected]; [email protected]'),
    ('[email protected];  [email protected]');

Select Test
From @T
Where SubString(Test, CharIndex('; ', Test) + 1, CharIndex(' [email protected]', Test,  CharIndex('; ', Test)) - CharIndex('; ', Test)) Not Like '^[ ]';