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