It's ISNULL() in SQL Server.
>Hi Al Doman
>Cannot use NVL() .... error return "Connectivity error : [Microsoft],[ODBC SQL Server Driver][SQL Server] 'NVL' is not a recognized function namee "
>
>>>Hi all
>>> How to make a oleboundcontrol.controlsource accept .Null. value
>>> using VFP via SQL Server 2000 ? Or maybe other solution...
>>
>>You could use NVL() in your view.
--sb--