The following works when typed directly into access, but fails with an 'Undefined function Nz' when run through Java and ODBC:
select * from [info] where
CInt(Nz(ValX, 0)) <= 100 and CInt(Nz(ValY, 0)) > 0 and CInt(Nz(ValY,0)) >= 100;
(100 is just a sample value)
I tried the IsNull, but that doesn't work. Basically my problem is that the 2 columns ValX and ValY are set as text and can be blank. I need to test against an integer in my java program on non-blank entries.
I read that Nz is an internal function only so it can't be used from a program. Is there an alternative that I can use in Java?