What error do you get?
Try

UPDATE client SET nLoansYTD = NVL(%loansytd%,0)

>I have a Sharepoint form that has number fields. These are treated as text fields in Sharepoint. When saving the form values I am attempting to UPDATE the VFP tables. If the user clears the text field of a number then saves the form's data, the variable seems to be evaluated before it gets to the OLEDB UPDATE. The cleared field evaluates to a NULL value. I cannot get the OLB DB statement to work with NULL values because, it seems, that the cleared variable is evaluated PRIOR to the UPDATE command.
>
>Has any one come across this? Am I missing something? I'm trying to stay away from scripts in the Sharepoint form.
>
>OLDDB chokes on each of the following:
>
>UPDATE client SET nLoansYTD = %loansytd%
>UPDATE client SET nLoansYTD = IIF(%loansytd%=.NULL., 0, %loansytd%)
>UPDATE client SET nLoansYTD = IIF(ISNULL(%loansytd%),0, %loansytd%)
>