I am trying to get this query to work and I am getting this error on this part...
ISNULL((SELECT SUM(dbo_pm30200.DOCAMNT) FROM dbo_PM30200
WHERE SUBSTRING(dbo_pm30200.DOCNUMBR,5,3) = "LDG" and dbo_upr00100.employid = dbo_pm30200.vendorid),0)
It says that it doesn't recognize SUBSTRING().
FEB LDG 02
What else could I use instead?