Custom SQL - SUBSTR

Morning,

I am swapping out a table in a custom SQL statement that connects to an Oracle DB. The statement worked before but now I am having issues and specifically SUBSTR.

The last part of my SQL statement looks like this:

FROM DTF_BUDGET_TABLE

WHERE PD_MO NOT IN (1,14)

AND AFC_CD = ‘JT’

AND (BUD_YR>= EXTRACT (YEAR FROM SYSDATE) – 4)

AND FUND_TYP =‘O’ AND

SUBSTR <>‘X’ AND SUBSTR <>‘T’ AND SUBSTR NOT IN (‘5′,‘7′,‘8′,‘9′)

Why does SUBSTR now not want to work?