Finding substrings after speical char in sqlserver

SELECT isnull((SELECT TOP 1 1

FROM SYNPROD.GETEMPINFORMATION
WHERE
(
LTRIM(RTRIM(SUBSTRING(GRADE, 0, CHARINDEX('-',GRADE,0))))NOT  IN ('b1' ,'b2','b3')

AND GRADE NOT  IN ('e2','e3','e0','e4','e1')
)
and userid=@USERID ) ,0
) [eligile]