>>>
>>>I changed the ".NULL." to "NULL" and still get the error. The syntax error is when I insert the record using SQLEXEC().
>>
>>Can you post your code that generates an error?
>
>This is a simplified version of my code:
>
>

>lfdate = "NULL"
>		
>cSqlInsert = "insert into Company (	MYDATEFLD ) values " + ;
>	"(" + "'" + lfdate + "'" + ")"
>
>nResult = SQLEXEC(hCon,cSqlInsert)	
>
>

Remove your sigle quotes from around the NULL value.

cSqlInsert = "insert into Company (	MYDATEFLD ) values " + ;
	"(" + lfdate + ")"