>The NVL function of VFP allows me to replace null information with desired alternative. NZ does a similar job in Aceess database. However, trying to use NZ in an ODBC SQLEXEC struct gives syntax error, :Undefined Function.
>
>Any Help ?
>
>Thanks
>Rakesh
You have to use the syntax and functions for the specific backend. For Oracle, the syntax would be WHERE somefield IS NULL
Mark McCasland
Midlothian, TX USA